davidz Posted May 11, 2007 Share Posted May 11, 2007 Is there a way with Mysql 4.1 that you can run an Update query to see what it will do (mainly make sure there are no syntax errors and such) but not have it actually modify the data? Quote Link to comment Share on other sites More sharing options...
effigy Posted May 11, 2007 Share Posted May 11, 2007 You should be able to mimic the behavior with a SELECT statement. Two other options that I'm aware of are: 1. Backup the database; if there's a problem, restore the database. 2. Use transactions if your tables are capable (InnoDB). Quote Link to comment Share on other sites More sharing options...
davidz Posted May 11, 2007 Author Share Posted May 11, 2007 You should be able to mimic the behavior with a SELECT statement. Two other options that I'm aware of are: 1. Backup the database; if there's a problem, restore the database. The database is too large to make this viable (more than 2 gigs). 2. Use transactions if your tables are capable (InnoDB). Tables are MyIsam. Thanks for the reply, I don't see any real way to make this simple either. Quote Link to comment Share on other sites More sharing options...
effigy Posted May 11, 2007 Share Posted May 11, 2007 How about only backing up the tables that will be affected instead of the entire database? You should always have a test environment for things like this any how... Quote Link to comment 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.