abazoskib Posted July 29, 2009 Share Posted July 29, 2009 what are the cons of running mysqldump with skip lock tables? my problem is that i have too many scripts running with cron 24 hours a day. each script accesses different tables, however if i want to backup my db i cant lock the tables. would using skip-locak-tables be ok? Link to comment https://forums.phpfreaks.com/topic/168025-mysqldump-skip-lock-tables/ Share on other sites More sharing options...
corbin Posted July 29, 2009 Share Posted July 29, 2009 If the tables aren't locked the data may change in the middle of the backup. That could have some weird side effects. Link to comment https://forums.phpfreaks.com/topic/168025-mysqldump-skip-lock-tables/#findComment-886269 Share on other sites More sharing options...
gassaz Posted July 29, 2009 Share Posted July 29, 2009 http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_single-transaction Link to comment https://forums.phpfreaks.com/topic/168025-mysqldump-skip-lock-tables/#findComment-886282 Share on other sites More sharing options...
abazoskib Posted July 29, 2009 Author Share Posted July 29, 2009 If the tables aren't locked the data may change in the middle of the backup. That could have some weird side effects. gassaz, i am using the MyISAM engine so a single transaction will not work corbin, what exactly are you referring to by weird side effects? i will be backing db up every day so if the only con is ill miss a few records, then thats a risk im willing to take. Link to comment https://forums.phpfreaks.com/topic/168025-mysqldump-skip-lock-tables/#findComment-886307 Share on other sites More sharing options...
fenway Posted August 3, 2009 Share Posted August 3, 2009 You may be getting inconsistent data across tables. Link to comment https://forums.phpfreaks.com/topic/168025-mysqldump-skip-lock-tables/#findComment-889955 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.