Mysqldump – Backup and Restore

Backup

mysqldump -u devise -ppassword -h 127.0.0.1 database_name > backup.sql

Restore

mysql -u -ppassword database_name < backup.sql

This entry was written by Matt Stone, posted on October 20, 2011 at 3:46 pm, filed under tech. Bookmark the permalink. Follow any comments here with the RSS feed for this post. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*