zohab Posted January 26, 2012 Share Posted January 26, 2012 Hi, I am taking mysql database backup using following mysqldump command. This command is working fine but I am getting lock tables statements before insert statement. mysqldump --user=root --password=mypassword --port=3306 -h localhost mydatabase --force > G:\myfolder\test.sql I do not want lock table statements therefore I use following options but these options not working. --single-transaction –lock-tables=false My database type is MyISAM Any solution? - Thanks. Zohaib. Link to comment https://forums.phpfreaks.com/topic/255808-mysqldump-without-lock-table-statements/ Share on other sites More sharing options...
fenway Posted January 26, 2012 Share Posted January 26, 2012 You do understand what without locking the tables your backups are useless.... Link to comment https://forums.phpfreaks.com/topic/255808-mysqldump-without-lock-table-statements/#findComment-1311424 Share on other sites More sharing options...
awpti Posted January 26, 2012 Share Posted January 26, 2012 As fenway said.. Also, --single-transaction is only relevant for InnoDB. I'd suggest you setup a slave and do backups from the slave. This avoids the impact of doing backups from the live dataset. Link to comment https://forums.phpfreaks.com/topic/255808-mysqldump-without-lock-table-statements/#findComment-1311465 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.