Mysql Dump Php

[Rmazin]

Hello,

Is there a PHP command to dump a MYSQL DB into the queries that populate it? I am trying to combine two tables in my DB and I dont want to have to manually if it can be avoided. I have seen this type of function before I'm just not sure how to do it.

Thanks.

[spikeZ]

Probably be better in the MySQL forum but depending on your MySQL Version, you might be able to do it in a nested sub-query.

(or just wait for someone to come along who knows.....!)

Spike

[lmasi02]

you can use system() function. This work well on linux coz u can execute mysql from any direcorate. Do a search on system() function

[stymiee]

I am fairly certain system() calling mysqldump is the only way to do ti through PHP. Well, other then using PHP's native mysql functions to mimic a dump but that's hardly worth the effort.

[Rmazin]

Thanks for the help I will study up on system(). I actually found a freeware script that does the table setup but I need the data out of the table as well. I have seen it done before where I enter a table name and the query history of the table returns. It is very helpful for backups and modifying table data.