Backing up MySQL Database with PHP

[TimTimTimma]

Ok, I have been browsing all over the internet, and searching for ways to backup my mysql database to a flat file however; all the scripts I find either just backup the data and not the structure or backup both but it only works if your hosting the db on your machine. Is there a script out there or a tutorial ANYWHERE that tells you how to backup your mysql's database structure and data?

[planetsim]

Have you looked into mysqldump its a program provided by MySQL.

mysqldump --user=username --password=mypass --all-databases > /path/to/file

[TimTimTimma]

my site is hosted on a remote server, so I dont have access to that, when I say I wish to use PHP, I mean using phpcode to backup mysql information

[planetsim]

Most hosts ive been with give user access to this although you may need to give direct access to it.

And yes I do know what you mean you can do this within PHP as a system command. However the PHP alternative is much harder. I do have one built however its built into an existing system, and would take some time for me to get it out and fixed up to work as a standalone.

[jerdo]

Try looking at the code for http://www.phpMyAdmin.net, it allows you to dump data and/or structure to a file. You might be able to use the code from there or just use phpMyAdmin.

[bradgrafelman]

Don't forget, all of this is assuming you have remote access, i.e. 'user@%' instead of 'user@localhost' in the MySQL priviliges table.