Exporting mysql db from PHP

[anders2002]

Hi,

Does anyone know how to export the contents of a mysql db via PHP? Ideally, I'd like to have a button on a website that will export the contents of the mysql DB to a text file (as you can using phpmyadmin) and save it away as a backup?

Many thanks,

Anders

 

[danielhozac]

Sure. Issue some queries like [tt]SHOW TABLES[/tt], [tt]DESCRIBE <table name aquired from previous query>[/tt], [tt]SELECT * FROM <table name>[/tt] and you just have to parse the data and turn it into SQL queries. //Daniel

 

[sleipnir214]

Or you could invoke mysqldump as an external application. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[anders2002]

Sorry to be a bit stupid but how can I invoke mysqldump as an external app?

 

[sleipnir214]

Through the use of the execution operator (

http://www.php.net/manual/en/language.operators.execution.php)

or one of the execution functions (links to them on the page pointed to by the previous link) Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!