MySQL Backup
May 6

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   May 6, 2004 8:34 AM    |   Follow Gadgetopia on Twitter   |  Tags:  MySQL

Comments

by Robert,   May 6, 2004 11:29 AM  

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

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.

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

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.

by Deane,   May 7, 2004 8:57 AM  

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

Add Comment