Wiki SQL Tips
From Koset Surakomol
SQL dump pages
MWDumper is a quick little tool for extracting sets of pages from a MediaWiki dump file.
http://www.mediawiki.org/wiki/MWDumper
It can be downloaded from http://download.wikimedia.org/tools/
My own SQL dump script
pre
day=`date +%Y%m%d-%H%M%S` dow=`date +%A` hour=`date +%d.%H`
cd /var/www/koset/sql \ echo -n Dumping sql ... \ mysqldump koset -uroot -pYourPaswdHere | gzip - koset.sql.$hour.gz \ echo ok \ chown apache:apache koset.sql.$hour.gz \ cd /var/www/koset/sql \ rm -f koset.sql.gz \ ln -s koset.sql.$hour.gz koset.sql.gz \ echo -n Done. Hour: \ echo $hour /pre
My SQL rebuild script
pre
cd /var/www/koset/sql \ mysqladmin -uroot -pYourPaswdHere -f drop koset \ mysqladmin -uroot -pYourPaswdHere create koset \ rm -f koset.sql \ cat koset.sql.gz | gunzip - koset.sql \ mysql koset -uroot -pYourPaswdHere koset.sql \ rm -f koset.sql \ echo SUCCESS: Rebuilt database. /pre
