Can PhpStorm upload MySQL database to sql file?

Question

I know that PhpStorm can connect to and work with a database. Is it possible to export the database to myDb.sql file using phpstorm?

Answer 1

As far as I know, you can export data from tables. Some types of databases allow Copy DDL any node.

More on

• http://blog.jetbrains.com/phpstorm/2013/10/database-tools-and-sql-editor-changes-in-phpstorm-7/ section Export Data
• http://www.jetbrains.com/phpstorm/webhelp/database-tool-window.html

Answer 2

No, there is no such option in phpstorm.

You can export only individual tables from the database by clicking ONE separate table (does not work if you select several tables) and open the mouse menu (right music). There you select "Save to file ..." a Select what you need (for example, "SQL Insert Statement").

To have a good DB-Client for managing all Material, use DBeaver (stand-alone version) or MysqlWorkbench. I prefer DBeaver.

Answer 3

In recent releases, you can right-click on a database and dump into a file. It exports individual files to a table.