Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

migrated from Jul 20 '10 at 20:41

This question came from our site for professional and enthusiast programmers.

marked as duplicate by Warner, John Gardeniers, Kyle Brandt Jul 20 '10 at 21:42

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

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

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.

share|improve this answer

MySQL Administrator provides easy backup and restore capabilities, and it's free.

share|improve this answer will perform an export of your databases.

share|improve this answer