Home > MySQL > MySQL Backup and Restore

MySQL Backup and Restore

March 12, 2011 Posted by KP

Backup single database
# mysqldump -u root -p db_name | gzip > sql.gz

Restore
# gunzip < sql.gz | mysql -u root -p db_name



Related Posts:

Filed Under: MySQL

Comments are closed.



Archives