Great product been using for years.
Almost always connect via SSH tunnel. Currently moving from one server to another. As a result I named the new DB the same with the same user/password.
One is using SSH tunnel via password, the other is private key. Both obviously have different IP addresses.
So when I tried to do a direct transfer from one server to the other via Export, I couldn't. It said that the tables don't exist. Even though I can see them, they are empty.
So I take a dump of a dev DB and put it into the new DB just to make sure permissions are set up properly etc.
THIS OVERWROTE THE OTHER DB BECAUSE I WAS CONNECTED TO BOTH.
It would seem that since they both have the same dbname/user/pass, even though they are on completely different IP with different tunnels, whichever you logged into last takes precendence.
So by running a script on my new server, I just unwillingly executed it on the live server and overwrote the live DB.
If you anyone can replicate this surely should be something to rectify.