Difference between revisions of "User:Aeric/Backup Notes"
From LongJump Support Wiki
imported>Aeric (Created page with ";Import:<tt>mysql -uName -pPW wikiNN < wikiNN_data.sql</tt>") |
imported>Aeric |
||
| Line 1: | Line 1: | ||
;Import:< | ;Export: | ||
:Easiest way is to use phpMyAdmin | |||
:-or- | |||
:{| | |||
<pre> | |||
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 | |||
</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: :{| <pre> cd /path_to_file bunzip2 [DBNAME].sql.bz2 mysql -uName -pPW wikiNN < wikiNN_data.sql