dump the entire db to SQL file via PHP

[itaym02]

Greetings.

I need to dump my entire db into a sql file (create + insert statments).
Is there a short way to do it via PHP?
If not, I probably have to do each table in the db, is there a way to get all the table names in the db (Assume I need it for several dbs - so the script can't know the table names and number in advance)

Thanks

[planetsim]

If you have access to the mysqldump program you could use a system function e.g. [man]system[/man], [man]exec[/man] etc to use that, otherwise you will need to view tables within the database, then what fields and field types and indexes are in each table and followed by what records are in the table.

[itaym02]

Thanks - that was what I needed