WampServer

is there any free program or php script that will allow me to backup my databases to an external HDD on my local server. I'm running sql locally on my wenserver at home. I have a PHP backup program but it will only backup to ftp can i run an ftp program locally on my server to just backup onto my external drive?

Hi,

If you want to do the backup manually, you can use the MySQL Administrator GUI tool from MySQL. You can either run it on the same box as your WAMP server is running, or connect to the database from a local workstation and save the backup file to the workstation. Backing up to an external drive is no problem.

In production environment I use a scheduled PHP command line (CLI) script which uses mysqldump. The database can be restored from the command line using the mysql command.

Regards,

toivo
Sydney, Australia