How Can I Automatically Backup My MySQL Database?

December 16, 2010 – 12:01 pm

Hi! I have a MySQL database that I want to automatically backup to my computer every hour. How can I do this? I prefer a simple solution.

Related posts:

  1. How Can I Automatically Backup My MySQL Database?
  2. How can I backup mysql database automatically?
  3. How can I backup mysql database automatically?
  4. How do you create an automatic backup for database designed in MySQL?
  5. How to backup/restore MySQL database without a plain dump?
  6. How to backup/restore MySQL database without a plain dump?
  7. Is searching a large MySQL database going to be a problem?
  8. How do you generally rate MySQL free version in compare with other database systems?
  9. What is the best approach to delete garbage and expired entries in a MySQL database?
  10. How do i build a interface to WRITE to my mysql database?
  1. 3 Responses to “How Can I Automatically Backup My MySQL Database?”

  2. You would have to write a php file that performs the MySQL dump as explained in the tutorial http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/ Then using a cron job you can have this php file called every hour. Most hosting packages include cron jobs.

    If you prefer another more elegant solution, try a software, such as Auto Backup for MySQL Professional Edition, a professional MySQL backup software. You can free download it at http://www.swordsky.com/pro_edition.html

    Hope this helps!

    By Takeshi on Dec 16, 2010

  3. If you are using phpmyadmin… Just go onto the database, and on the menu options, press export and follow the on-screen options.

    Hope that’s what you’re looking for.

    By Jhey on Dec 16, 2010

  4. Doing it automatically depends on whether it’s running on a Windows box (a .bat file) or a Linux box (a shell script). You can find examples of each on the web. Use the current date and tile as part of the backup file’s name if you want to retain more than one backup.

    By Colanth on Dec 16, 2010

Sorry, comments for this entry are closed at this time.