ZombieBento Posted March 23, 2010 Share Posted March 23, 2010 I just made a noob mistake. I didn't specify where to update in a database I'm working with so.. it kinda updated the whole thing. Luckily, it's still in the testing phases and not very big yet. Quote Link to comment https://forums.phpfreaks.com/topic/196268-mysql-mess-up/ Share on other sites More sharing options...
salathe Posted March 23, 2010 Share Posted March 23, 2010 It happens to everyone* -- nooby or otherwise. * Except those who are... liars Quote Link to comment https://forums.phpfreaks.com/topic/196268-mysql-mess-up/#findComment-1030690 Share on other sites More sharing options...
Daniel0 Posted March 23, 2010 Share Posted March 23, 2010 Then use a client that doesn't auto commit transactions so you can rollback. Quote Link to comment https://forums.phpfreaks.com/topic/196268-mysql-mess-up/#findComment-1030700 Share on other sites More sharing options...
JonnoTheDev Posted March 24, 2010 Share Posted March 24, 2010 I just made a noob mistake. I didn't specify where to update in a database I'm working with so.. it kinda updated the whole thing. Luckily, it's still in the testing phases and not very big yet. Always best to use a test database for development. Take daily backups. Quote Link to comment https://forums.phpfreaks.com/topic/196268-mysql-mess-up/#findComment-1030953 Share on other sites More sharing options...
oni-kun Posted March 25, 2010 Share Posted March 25, 2010 I just made a noob mistake. I didn't specify where to update in a database I'm working with so.. it kinda updated the whole thing. Luckily, it's still in the testing phases and not very big yet. I have another domain on the same network purely for that use, It runs intranet to transfer nightly backups to the 'database archive' I created, since it's internal bandwidth it's fairly fast. Quote Link to comment https://forums.phpfreaks.com/topic/196268-mysql-mess-up/#findComment-1031441 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.