Backup

Senior WebHelper Joined: 21 Apr 2003 Posts: 153

Does anyone have a good MySQL backup program?

Team Member Joined: 06 Jan 2002 Posts: 2564

This is what we use at 4WebHelp, in our cron file:

Code:

0 0 * * 1 /usr/local/psa/mysql/bin/mysqldump -uUSERNAME -pPASSWORD DATABASE_NAME |gzip |uuencode database_backup.sql.gz |mail EMAIL_ADDRESS -f"4WebHelp Database Backup"

But that will email it to you... I'll see if I can dig up the code to save it somewhere on the server, if you need it? Question

Posted: Sat Apr 26, 2003 10:43 am (21 years, 8 months ago)

Hi,

Either that or you can use phpMyBackup. Goto http://www.phpmybackup.com/.

phpMyBackup can be used from the web or for cron jobs and scheduled backups of complete db's, tables etc. It can gzip up the backup. It can also ftp a backup of database to a specific ftp server.

Hope that helps...

Cheers, Norm Very Happy

Senior WebHelper Joined: 21 Apr 2003 Posts: 153

How would I put that code in here to email me a backup once a week?

Team Member Joined: 06 Jan 2002 Posts: 2564

0 in the first box, 0 in the second, * in the next two, 1 in the fifth. Put the rest in the command box. This will email you in the night, between Sunday and Monday.

Code:

0 0 * * 1 /usr/local/psa/mysql/bin/mysqldump -uUSERNAME -pPASSWORD DATABASE_NAME |gzip |uuencode database_backup.sql.gz |mail EMAIL_ADDRESS -f"Database Backup"

Posted: Wed May 07, 2003 4:51 pm (21 years, 7 months ago)

assuming the server uses plesk...

Team Member Joined: 06 Jan 2002 Posts: 2564

Oops... Of course it won't, since that was a CPanel screenshot. You'll have to replace "/usr/local/psa/mysql/bin/mysqldump" with the appropriate command for your OS.

Senior WebHelper Joined: 21 Apr 2003 Posts: 153

how do I know the command? I know the servers running on RedHat Linux 8.0.

Posted: Thu May 08, 2003 3:50 pm (21 years, 7 months ago)

I can't seem to find anything in cpanel that would tell you, try running the following script:

Code:

<?php
header('Content-type: text/plain');
print system('locate mysqldump');
?>

it should be in there somewhere Wink