Menu
▾
▴
[Semediawiki-user] Re : Upgrading to SMWSQLStore3 (?)
|
From: Nicolas N. <pm...@ao...> - 2012-12-20 18:43:37
|
Thanks Karsten, I will paste it on the installation guide of SMW 1.8 Do you know if we can rue the runJobs.php script for accelerate the refresh of Data ? If I understand correctly steps 5,6 and 10,11 are done during the date refreshes ? Thanks for this solution Cheers Nicolas NALLET > http://semantiki.fr > http://domotiki.eu -----E-mail d'origine----- De : [[kgh]] <med...@kg...> A: semediawiki-user <sem...@li...> Envoyé le : Je, 20 Déc 2012 17:49 Sujet : Re: [Semediawiki-user] Upgrading to SMWSQLStore3 (?) Heiya, I have just successfully migrated one wiki to SMWSQLStore3 without using the shell or other voodoo. However this may take some time for big wikis due to the time the two data refreshes need. Still you wiki will be fully functional since you use SMWSQLStore2 during the time the two data refreshes need. If you are on a public wiki you will want to follow these steps: 0) Back up you installation and database 1)Set $wgReadOnly = 'site maintenance'; in your LocalSettings.php 2) Move the new files for SMW and Validator into the extensions directory 3) Go to Special:SMW-Admin and hit "Initialise and upgrade tables" 4) Return to Special:SWM-Admin and hit "Start updating data" 5) Add $smwgDefaultStore = 'SMWSQLStore2'; to your LocalSettings.php below the enableSemantics line 6) Comment out $wgReadOnly = 'site maintenance'; 7) After the data refresh is done you do step 1) again 8) Comment out $smwgDefaultStore = 'SMWSQLStore2'; in your LocalSettings.php 9) Do step 4) again 10) Do step 5) again 11) Remove $wgReadOnly = 'site maintenance'; from your LocalSettings.php 12) After the second data refresh is done you remove $smwgDefaultStore = 'SMWSQLStore2'; from your LocalSettings.php 13) Voilà, your are on SMWSQLStore3. Paradise regained. :) If you are sure that nobody will edit the wiki during this process (e.g. closed wiki) you may drop the steps containing $wgReadOnly Cheers Karsten Am 20.12.2012 16:21, schrieb Nicolas: > I have a shared hosting too and I can only execute php file like php > /home/yourlogin/www/mediawiki/extensions/semanticmedia > wiki/maintenance/SMW_refreshData.php > but without arguments because spaces are forbidden. > > I will try to workaround that by creating 2 new php files : > > http://semantic-mediawiki.org/wiki/Semantic_MediaWiki_1.8.0/php_SMW_refreshD > ata.php_-v_-b_SMWSQLStore3_-fp > http://semantic-mediawiki.org/wiki/Semantic_MediaWiki_1.8.0/php_SMW_refreshD > ata.php_-v_-b_SMWSQLStore3 > > In which "if conditions" of arguments like -b -v -fp are hard coded with 1 > (so they are always true) and the argument option of -b is hardcoded with ' > SMWSQLStore3 '. > > If somebody who knows php language could check if everything is ok before my > attempt it could be nice. > > Thanks, > > Nicolas NALLET > http://semantiki.fr > http://domotiki.eu > > > -----Message d'origine----- > De : Martin Renvoize [mailto:ash...@gm...] > Envoyé : jeudi 20 décembre 2012 13:38 > À : sem...@li... > Objet : Re: [Semediawiki-user] Upgrading to SMWSQLStore3 (?) > > If your shared hosting is of the cPanel variety then you can often run these > scripts through the cronjobs. > > Login to your cPanel and find the schedule jobs section. Then schedule a job > to run the script. > > The line will probably look something like: php > /home/yourlogin/www/mediawiki/extensions/semanticmedia > wiki/maintenance/SMW_refreshData.php -v -b SMWSQLStore3 -fp > > It should then email you the rwsu its nice run.. after it has run remember > to go and delete it from the cron out it will keep running on the interval > you set. > > Hope that helps somebody, happy to clarify when I'm back at the pc if anyone > asks > > Martin > Hi Cav, > > I have the same issue like you (no shell access). > I already posted to the developer mailing list and opened a thread here: > > http://semantic-mediawiki.org/w/index.php?title=Help_talk:Installation&offse > t=20121219101445&lqt_mustshow=388#How_to_migrate_to_SMWSQLS > < > http://semantic-mediawiki.org/w/index.php?title=Help_talk:Installation&offse > t=20121219101445&lqt_mustshow=388#How_to_migrate_to_SMWSQLStore3_without_she > ll_access.3F_336 > Any help is highly appreciated. > > Thanks, > Stefan > > >> Message: 7 >> Date: Thu, 20 Dec 2012 10:30:45 +0000 >> From: Cavila Contrafibularity<con...@ho...> >> Subject: Re: [Semediawiki-user] Upgrading to SMWSQLStore3 (?) >> To:<ral...@kr...>, >> <sem...@li...> >> Message-ID:<SNT...@ph...l> >> Content-Type: text/plain; charset="iso-8859-1" >> >> >> >> Thanks. I'm just an ordinary user on a shared host, so I don't have > access to the command line. >> Cav > -- > InterSpirit.de <http://interspirit.de> > Spirituelle Websites & Internet-Marketing > ---------------------------------------------------------------------------- > -- > LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely > access PCs and mobile devices and provide instant support Improve your > efficiency, and focus on delivering more value-add services Discover what IT > Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > ---------------------------------------------------------------------------- > -- > LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely > access PCs and mobile devices and provide instant support Improve your > efficiency, and focus on delivering more value-add services Discover what IT > Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > > > ------------------------------------------------------------------------------ > LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial > Remotely access PCs and mobile devices and provide instant support > Improve your efficiency, and focus on delivering more value-add services > Discover what IT Professionals Know. Rescue delivers > http://p.sf.net/sfu/logmein_12329d2d > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > ------------------------------------------------------------------------------ LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more value-add services Discover what IT Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d _______________________________________________ Semediawiki-user mailing list Sem...@li... https://lists.sourceforge.net/lists/listinfo/semediawiki-user |