User:Aeric/Backup Notes
From LongJump Support Wiki
< User:Aeric
Revision as of 00:53, 6 August 2011 by imported>Aeric
- Export
- Easiest way is to use phpMyAdmin
- -or-
mysqldump -u[USERNAME] -p[DBNAME] | bzip2 > [/path_to_file/DBNAME]_data.sql.bz2
- Import
cd /path_to_file bunzip2 [DBNAME].sql.bz2 mysql -uName -pPW wikiNN < [DBNAME]_data.sql