Backup MySql database with PHP

dinko77

New Member
I have a pretty large db in MySql, and I need to take backups of it every day or so.I need to be able to take backups from any computer, so therefore I thought about making a php script to do this and put this php script online (offcourse with password protection and authorization etc so that only I can access it).I wonder however, how is this done properly?What commands should I use, and is it possible to change settings of the backup (for instance \[code\]Add AUTO_INCREMENT value = http://stackoverflow.com/questions/3595976/true\[/code\])?I would appreciate examples...Also, if this is a bad method (unsafe, or maybe gives bad backups with bad sql files), what other method would be preferred?I have shell-access and I have a VPS (ubuntu server).My Mysql version is 5.1Thanks
 
Back
Top