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 105 times
0
-
Please give some more information. How is anybody supposed to answer this like that. What operating system? Is it a remote or local server? Where do you want to do the backup to? – Pekka Jul 20 '10 at 20:44
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,553
- 2
- 24
- 33
0
MySQL Administrator provides easy backup and restore capabilities, and it's free.
0
http://www.phpmyadmin.net/home_page/index.php will perform an export of your databases.
gnome
- 113
- 3