User:WikiSysop/TECH

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

Error message: Cannot get command line arguments, register_argc_argv is set to false (TODO: Investigate).
/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