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.

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…

NAME

URL

Markdown syntax is supported. Use ">" to blockquote text.

COMMENT