Difference between revisions of "User:Aeric/Backup Notes"
From LongJump Support Wiki
imported>Aeric |
imported>Aeric |
||
| Line 5: | Line 5: | ||
<pre> | <pre> | ||
mysqldump -u[USERNAME] -p[DBNAME] | bzip2 > [/path_to_file/DBNAME].sql.bz2 | mysqldump -u[USERNAME] -p[DBNAME] | bzip2 > [/path_to_file/DBNAME].sql.bz2 | ||
</pre> | |||
|} | |} | ||
Revision as of 00:52, 6 August 2011
- Export
- Easiest way is to use phpMyAdmin
- -or-
mysqldump -u[USERNAME] -p[DBNAME] | bzip2 > [/path_to_file/DBNAME].sql.bz2
- Import
cd /path_to_file bunzip2 [DBNAME].sql.bz2 mysql -uName -pPW wikiNN < wikiNN_data.sql