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

Another way to backup without locking my mysql tables?


abelvi59
2016-05-22, 10:33 PM
I do backups in my web site every day with a cronjob which uses a simple mysqldump command, i see that every time this is running all the mysql tables are locked during the process and website is down for some hours all the time.

can you guys help me please could provide be the best alternative to do this and minimize downtime ?

My tables are a mix of InnoDB and MyISAM.

this its my web site http://www.playboyrevistapdf.com/

Thanks