May have uncovered a nasty bug

[expired user #11050]'s profile image [expired user #11050] posted 6 years ago in General Permalink

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.

Thanks

Please login to leave a reply, or register at first.