CODEWITHSUNDEEP
databasemysqlphpstorm
Sebas Zella
Sebas Zella

Reputation: 177

Can PhpStorm dump a MySQL database into a sql file?

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

Upvotes: 17

Views: 27255

Answers (5)

Daniyal Nasir
Daniyal Nasir

Reputation: 707

As of phpstorm 2019.2.5 you can

right-click your database/schema > Dump To FIle(s) > SQL Inserts

to export you DB Structure and Data, see below image for ref.

screenshot of toolbar

Upvotes: 0

Michael Cordingley
Michael Cordingley

Reputation: 1525

As of this writing (2018.1), right clicking on a database gives you the option to "Dump with 'mysqldump'".

Upvotes: 11

Joshua Wooward
Joshua Wooward

Reputation: 1508

In the latest editions you can right click on a Database and dump to file. It exports to individual files per table.

Upvotes: 3

suther
suther

Reputation: 13578

No, in phpstorm there is no such option.

You only can export single Tables from the Database by clicking on ONE single Table (doesn't work if you mark more than one Table) and open Mouse-Menu (right mouseclick). There you choose "Save to File..." an Choose what you need (for example " SQL Insert Statements".

For having a good DB-Client to manage the whole Stuff, use DBeaver (Standalone Version), or MysqlWorkbench. I preffer DBeaver.

Upvotes: 8

Michal Brašna
Michal Brašna

Reputation: 2323

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

More at

Upvotes: 5

Related Questions