User:WikiSysop/TECH

INDEX: http://www.tunearch.org/wiki/Ah!_Sure_Such_a_Pair

TUNEARCH PROCEDURES

DB CONNECT mysql --user=tunearch_user --password=AD41f018 --database=tunearch_wikidb

DB SELECT SELECT * FROM page where page_title = '<ARTICLE>'; SELECT * FROM smw_ids where smw_id = <SOME_ID;

MYSQLDUMP /usr/bin/mysqldump -u tunearch_user --password=AD41f018 --default-character-set=latin1 tunearch_wikidb -c | /bin/gzip -9 > ~/public_html/tunearchftp/TuneArch-$(date '+%Y%m%d').sql.gz

XMLDUMP /usr/bin/php -n -d register_argc_argv=true /home/tunearch/public_html/w/maintenance/dumpBackup.php --full | /bin/gzip -9 > ~/public_html/tunearchftp/TuneArch-$(date '+%Y%m%d').xml.gz

PHP
/usr/bin/php -n -d register_argc_argv=true

scp tunearch@184.154.160.18:/home/tunearch/backup/TTA-20110430.xml.gz .
password: TI46;DSC;A

UPGRADE
tar xvzf mediawiki-1.17.0.tar.gz -C /path/to/your/wiki/ --strip-components=1

INDEXING
cronjob
/home/tunearch/opt/usr/bin/indexer --quiet --config /home/tunearch/opt/etc/sphinx/sphinx.conf --rotate > /dev/null 2>&1

manual indexing
/home/tunearch/opt/usr/bin/indexer --config /home/tunearch/opt/etc/sphinx/sphinx.conf --all

SEARCH DAEMON
start
/home/tunearch/opt/usr/bin/searchd --config /home/tunearch/opt/etc/sphinx/sphinx.conf

stop
/home/tunearch/opt/usr/bin/searchd --config /home/tunearch/opt/etc/sphinx/sphinx.conf --stop

SIDEBAR

• • Special:RunQuery/LinkedInForm|Tune Connections

Rebuilding everything

The above methods should be able to fix data records in SMW in most cases. However, it is conceivable that some erroneous content of the SMW storage still persists for some reason. In this case, it makes sense to completely delete and reinstall the database structures of SMW before refreshing all data. To completely delete all SMW data, the setup script SMW_setup.php is used with parameter --delete:

php SMW_setup.php --delete

After this, proceed as if re-installing SMW anew by first running php SMW_setup.php again, and then triggering the repair of all data using one of the above methods. The refresh script SMW_refreshData.php can be also used with parameter -f to delete and recreate all data in one step. In this case, it is suggested to first rebuild the records for all properties and types, and to process the remaining data afterwards. So one would run:

php SMW_refreshData.php -ftpv
php SMW_refreshData.php -v

Note that of course only the first run uses -f. On large wikis, the parameters -s and -e can again be used as explained in the previous section.