I do development on a corporate server, and the admin doesn't permit access to run the mysqldump command from a php script.
So, I'm bascially looping through each table and dumping the contents in a text file formatted to output a proper sql file.
How would I write an SQL statement to retrieve the tables names in a given database? Right now I have to give the script all the table names in an array and then loop the queries through. Would be much nicer if I didn't have to update my script every time I add or remove a table.
