MySQL backup and restore

written by Jerod on May 19th, 2008 @ 09:02 AM

Create the backup

   1   mysqldump --add-drop-table -h [hostname] -u [username] \
   2   -p [databasename] > [backupfile].sql

Optionally

Specify a table -

   1   ...[databasename] (tablename tablename tablename) ...

Add compression -

   1   ...[databasename] | bzip2 -c > backupfile.sql.bz2

Restore from backup

   1   mysql -h [hostname] -u [username] \
   2   -p [databasename] < [backupfile].sql

Optionally

Uncompress before restoring -

   1   bzip2 -d backupfile.sql.bz2

0 comments

Options: