[SOLVED] Backing up a MySQL database without mysqldump

[friedemann_bach]

Hello all,

 

I have designed a small MySQL database frontend with PHP and I want to provide a backup function that creates a dump of the whole database. Usually, I would have used mysqldump with the usual command line options. However, mysqldump does not work here, as the PHP server does not have mysql installed. The mysql server is running on another machine. How can I make a complete database backup in this case - using only PHP and MySQL commands?

 

Thank you very much for your help.

 

[trq]

Take a look at mysql's SELECT syntax (here). You can use the INTO clause to send to a file.

 

eg;

 

mysql_query("SELECT * INTO OUTFILE 'filename.sql' FROM tblname");

[friedemann_bach]

Thank you very much for this hint!