MYSQL Database Backup Scripts

[Limit]

Do any of you know where i can find a script that will allow me to back up a whole mysql database as a sql file?

[kwvarga]

phpMyAdmin does it

[Limit]

I know that lol.

Is there a way you can do it with a php page as one of my clients doesn't really know how phpmyadmin works.

[Emancipator]

what value is it to him if he cant even use phpadmin? Or are you going to do an import function as well?

I have never done it, but it most certainly can be.

[fishfreek]

Set up a cron job that runs the following command

[code:1:00e14b2720]mysqldump -u(username) -p(password) (databasename) > (pathtofilelocation)(filename.sql)[/code:1:00e14b2720]

So lets use this format using the following peramiters

Username: JohnSmith
Password: Toga
Databasename: FratHouse
Path to File location: /home/JohnSmith/
Filename: Brothers.sql

[code:1:00e14b2720]mysqldump -uJohnSmith -pToga FratHouse > /home/JohnSmith/Brothers.sql[/code:1:00e14b2720]

This will do a mysql dump of the FratHouse database that has been setup with the user permissions of JohnSmith and a password of Toga and place the sql dump in the home directory of JohnSmith.

THen just set the cron job peramiters to run as frequent as you want. If you want to really get complex then you can add some time/date variables to the filename so that the filename is created with a time/date stamp in the filename so when the cron job runs again it does not overwrite the previous file.

[sim]

Cant you make backup's from your sql panel? I think its on my host.

[fishfreek]

Yes but that would not be automated.