mysql backups
Memo to self:
To back up the databases in shell via ssh do:
mysqldump -h localhost -u xxxxx -p db_name > backup-file.sql
restore with
mysql -h localhost -u xxxxx -p db_name < backup-file.sql
Related Posts
No related posts.
| Print article | This entry was posted by Andy Bird on February 3, 2009 at 10:33 am, and is filed under mysql. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site. |