We are in the process of migrating this forum. A new space will be available soon. We are sorry for the inconvenience.

Best way to backup without locking mysql tables?


24x7servermanagement
2016-05-06, 02:55 AM
You Need to use " --lock-tables=false" options in mysqldump command. The otherway will be to generate Tar or zip backups for the mysql databases using some customized backup scripts.

Daniweb
2016-05-04, 09:24 PM
I do backups every night with a cronjob which uses a simple mysqldump command, however i see that every time that this is running all the mysql tables are locked during the process and website is down.

Which would be the best alternative to do this and minimize downtime ?

My tables are a mix of InnoDB and MyISAM.

Thanks