Possible Duplicate:
Optimal way to make MySQL backups for fairly large databases (MyISAM / InnoDB)
What is the best way to backup a MySQL database? Is there a way to automate that process?
Asked
Active
Viewed 112 times
3 Answers
1
mysqldump --opt --all-databases | gzip > /path/to/backup/mysql.$(date -Ihour).sql
To automate it just add it to your crontab. But the comments are right, if you give us some more info, we can give a better answer.
James
- 7,809
0
MySQL Administrator provides easy backup and restore capabilities, and it's free.
