Menu
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?
906
4 mysqldump — A Database Backup Program. The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table data. It dumps one or more MySQL databases for backup or transfer to another SQL server.
As of this writing (2018.1), right clicking on a database gives you the option to "Dump with 'mysqldump'".
50
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.
44
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
