Is there an easy way to completely copy the structure and data from one database source to another through PhpStorm? Literally a clone... teardown the old, bring in the new.
I have a PROD db, a TEST db (same server but different location/db than PROD), and a local DEV db. I'm trying to figure out the fastest way to be able to wipe out the DEV/TEST dbs and import the live PROD data, so that my data's as fresh as possible when I start work. I read something in a JetBrains post about using a migration feature, but it doesn't seem to exist. I'm not sure if it was just odd wording on the page, or if the feature was removed in a previous version for some reason, but I can't figure out a way to do this.
It sounds like I may be able to accomplish something similar by exporting my PROD db to a DDL file and then importing that into the DEV/TEST dbs, but it doesn't seem like it's as fast as a few clicks. On my pre-PhpStorm setup I did all the work on my actual web server, and I had a bash script setup to do the database replicating in a matter of seconds, and if it's possible I would like to get something similar setup via PhpStorm.
PS - As a note to new users, don't select your entire post, click the font dropdown, and then hit the first letter of the font you want to use. Instead of going to that font on the list and updating your post, it replaces your entire post with the character you pressed, and unlike most other forms you can't use CTL-Z to recover it and you have to re-type your post.