server-side code to export an entire database from mysql

Asked Jun 30 '14 at 10:32

Active Jun 30 '14 at 10:44

Viewed 54 times

I know that you can export a database from phpmyadmin. Is there a way of sending a an sql query that will export all the tables with information?

the script will go as follows:

For example, in phpmyadmin you can select a database and "export all tables" as SQL.

I think I'm looking for a select statement something along the lines of: SELECT all tables FROM database

edited Jun 30 '14 at 10:44

asked Jun 30 '14 at 10:32

Zach Smith

1

check [this](http://stackoverflow.com/questions/935556/mysql-dump-by-query) – epipav Jun 30 '14 at 10:34
is there a way you can do that with a query? – Zach Smith Jun 30 '14 at 10:42
1

SELECT * FROM db INTO OUTFILE 'example.txt'; this export as .txt, however exporting as .sql files i guess there is no other way but using mysqldump. – epipav Jun 30 '14 at 10:47

0 Answers0