By Deane Barker | May 6, 2004 | 5 Comments
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.
PHPMyAdmin has just such a script as part of it http://www.phpmyadmin.net/home_page/
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.
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!
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.
Yeah, that was pointed out to me. Sometimes we overlook the most obvious solutions…