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:
- MySQL Backup and my.cnf
- Backup Script
- MySQL Optimization
- Monitor MySQL Log File
- Optimizing MySQL
- MySQL Start Script
- Create MySQL User
- Tar Command
Filed Under: MySQL