Automated mySQL backups or phpAdmin?

[bi11i]

I'm sure there's an answer to my question somewhere in here, I just can't seem to find it.

I'm trying to find a way to backup ALL of my SQL databases into .sql files from only a simple command or batch file. I have 17 different databases in mySQL and use phpAdmin to back them up, one at a time, but is there a way for me to back them all up at once?

I'm currently exporting the .sql files from phpAdmin, which can be a time consuming process. Then I burn the sql files to a CDR. What I'd like to do is to be able to run one command that would back them all up into a central/specific directory (possibly a command I could schedule?) rather than go through the whole process weekly.

Any advice for someone who knows just enough to be dangerous?

[DelphiVillage]

for the vbulletin database you could check this (http://www.vbulletin.org/forum/showthread.php?t=62149) for the other databases you use i'm pretty sure it's possible if you have cron access but it requirers a unix shell script (bash and such) and i'm the wrong person to make suggestions about that but it should be possible with just one command you could make a suggestion to the developers of PhpMyAdmin don't know if they will listen through) this must be possible with a *.sh script

i was bored and did a websearch on your problem and i found something that might be interesting to you click here (http://sourceforge.net/projects/automysqlbackup) that shell script allows you to backup MySQL databases you specify

[fire27]

there is always phpMyBackupPro on source forge i have this set up to backup the db and ftp it elsewhere

[Dave#]

dpending on the size of yourr databases - mysqlhotbackup may be a better solution

[bi11i]

thanks! these are all great. and exactly what i was looking for.

thanks for the help!

[Byron]

Which of these backup script is most suitable for large sql files and also more secured?

[bi11i]

I fought and fought with phpMyBackupPro and finally got it working correctly. It has some very general error messages (at least if you're using IIS) so don't look to them for specific solutions if you get them. I was able to do fairly large and scheduled backups with this software, although there seems to be a 180 second timeout somewhere in the PHP itself (and not in PHP.ini, like I originally thought.)

You might need to tweak the 180 second timeout, but other than that, I bet it would work for you just fine...
Which of these backup script is most suitable for large sql files and also more secured?

[Icheb]

The most reliable script would be one that uses mysqldump from the shell :) .

[Byron]

Just to confirm: Is this command to dump and gzip the database correct? Does it backup my database safely and completely?

mysqldump --opt -q -uADMIN -pPASSWORD DATABASENAME | gzip > /Server/Path/BackupFileName.sgl.gz

[eva2000]

yeah i usually leave off the -q command but check out this guide too for alternate means of backing up http://www.vbulletin.com/forum/showthread.php?t=134821