Generate a single sql file containing Drop, Create, Insert statements for multiple tables? #37246
-
I've looked up and down every documentation I can find, as well as clicked through the software everywhere I could think of, and can't seem to find this option. Is it hiding somewhere? I'd like to be able to select multiple tables, and then generate a .sql file that contains the appropriate DROP IF EXISTS, CREATE TABLE, and INSERT INTO commands required to rebuild those tables - similar to how a server backs up databases into a single .sql file. Am I missing something? Thank you! 🙏 |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
I found it. What I was looking for is a native mysqldump, so rather than going to Export Data, I just want to go to Tools -> Dump Database, and it looks like it will give me exactly what I want. 🌟 |
Beta Was this translation helpful? Give feedback.
I found it. What I was looking for is a native mysqldump, so rather than going to Export Data, I just want to go to Tools -> Dump Database, and it looks like it will give me exactly what I want. 🌟