User:Aeric/Backup Notes

Export

Easiest way is to use phpMyAdmin

-or-

mysqldump -u[USERNAME] -p[DBNAME] | bzip2 > [/path_to_file/DBNAME].sql.bz2
|}

;Import:
:{|
<pre>
cd /path_to_file
bunzip2 [DBNAME].sql.bz2
mysql -uName -pPW wikiNN < wikiNN_data.sql