Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : PHP Backup Script For Remote MySQL and Email it!

[senaia]

Hello,

Im looking for a simple php script that will be placed on a linux server. The script job would be to connect to mysql on a windows server, create a full backup for the database, then email me the backup. The script should run automaticly once a day.

Any ideas?
Thanks!

[cselzer]

Would be more effective to use bash. I did a search on google and found a few for you that you can easily adapt that would email the contents... but email isn't really realistic imo, it would be best to mount a drive or upload remote (preferably a cloud), on 2 of my personal sites, i use command line dropbox and have the backups placed in a folder in dropbox and can manage it that way.

http://bash.cyberciti.biz/backup/bac...base-server-2/
http://snippets.dzone.com/posts/show/4172
http://crunchbang.org/archives/2007/...-mysql-backup/ ---- this one can perform a remote backup.
http://paulbradley.tv/38/ --- email support via perl, looks very easy to setup.
I think they both would be effective if setup properly. I personally backup every 6 hours.

[CoderJosh]

Check out http://sourceforge.net/projects/automysqlbackup/ for a shell script that can backup remote SQL servers and e-mail the files.

[iTom]

Originally Posted by cselzer

Would be more effective to use bash. I did a search on google and found a few for you that you can easily adapt that would email the contents... but email isn't really realistic imo, it would be best to mount a drive or upload remote (preferably a cloud), on 2 of my personal sites, i use command line dropbox and have the backups placed in a folder in dropbox and can manage it that way.

http://bash.cyberciti.biz/backup/bac...base-server-2/
http://snippets.dzone.com/posts/show/4172
http://crunchbang.org/archives/2007/...-mysql-backup/ ---- this one can perform a remote backup.
http://paulbradley.tv/38/ --- email support via perl, looks very easy to setup.
I think they both would be effective if setup properly. I personally backup every 6 hours.

Originally Posted by CoderJosh

Check out http://sourceforge.net/projects/automysqlbackup/ for a shell script that can backup remote SQL servers and e-mail the files.

By the looks of the first post he is wanting to do it on a Windows server, neither of these I think would work as their designed for Linux.

Are you familiar with any programming languages such as PHP?

[senaia]

The MySQL database is located on windows 2003 server, I need to install a php script on a linux server to connect daily to windows server, backup/email the database.

Yes, I prefe something in php since im used to it.

[CoderJosh]

Originally Posted by iTom

By the looks of the first post he is wanting to do it on a Windows server, neither of these I think would work as their designed for Linux.

The OP mentioned that the script should run on a Linux server and MySQL is running on a Windows server.

The script I've linked to can be used in this scenario, it's a rather simple shell script that should run on any Linux server without any problems. Whether the MySQL server is a Linux or a Windows machine shouldn't make a difference.