Geek and you shall find…

MySQL Backup

Mysql Backup: Here’s a good-looking program and a relatively rare example of an open-source Windows program,

Mysql Backup is a program to backup your mysql databases. You can backup multiple databases and or tables all saved to a SQL file. It also has an scheduler so you can backup your database regularly

However, what I really need is a PHP script that will generate the MySQL dump so I can use a client script to grab it every night.

By Deane Barker | May 6, 2004

Comments

  1. Comment by Robert, May 6, 2004 11:29 am

    PHPMyAdmin has just such a script as part of it http://www.phpmyadmin.net/home_page/

  2. Comment by Deane, May 6, 2004 11:34 am

    Well, yeah, I know, but can you call just that script as a URL with all the necessary parameters embedded? I’d like to do this via WGet every morning at 2 a.m. and save the result, but I don’t think it’s possible.

  3. Comment by Mean Dean, May 6, 2004 12:54 pm

    Click on my name, you’ll get directed to an article about a little Perl script I wrote back in April of ’03 entitled : backUpMySQL.pl

    Use with crontab, and you’re all set!

    http://www.healyourchurchwebsite.com/archives/000802.shtml

  4. Comment by Jon, May 7, 2004 1:30 am

    Couldn’t you just write a command-line script that PHP exec()s a mysqldump command to a file, running on cron? I’m doing that. Then you could auto-grab the file and do what you will with it.

  5. Comment by Deane, May 7, 2004 8:57 am

    Yeah, that was pointed out to me. Sometimes we overlook the most obvious solutions…