How do I backup mysql

[artemide]

I'm looking for a way to backup mysql. I tried using mysqldump unsuccessfully. I even bought a cgi script from perlonline.com, called advBackup to do it for me, which didn't work. Their support told me that my host (powweb) is not allowing me access to mysqldump. Does anyone know anything about this?

My site is hosted on charon.powweb.com and mysql is on mysql01.powweb.com. I'm looking to make a one click solution where the user clicks on a 'backup the database' link to backup. I would like to use mysqldump because it seems to be the simplest solution, it powweb supports it. How would I access it though?

[irasmith]

You might want to give this thread a read (http://forum.powweb.com/showthread.php?s=&threadid=20022&highlight=backup) on how to do backups of your data as another user here on the forum wrote this script. The author is quite knowledgeable and I use the script to backup my database all the time.

The script does use the mysql dump function and you can see it being called as you read through the script.

You may want to check this link on my site out (http://www.irarichardsmith.com/modules.php?op=modload&name=Sections&file=index&req=viewarticle&artid=11&page=1) for a recap and links to several MySQL administration tools through which to administer your MySQL database(s).

Not sure if you are seeking to have another user do backups for your or if you are going to do them yourself, but there should be lots of information above for you to choose from.

Hope this helps you out.