Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 stackoverflow.com 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

3 Answers 3

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

http://www.phpmyadmin.net/home_page/index.php will perform an export of your databases.

share|improve this answer