Re: Backuping MySQL-databases

A locked mysql database works faster. If you use mysqldump to backup, it's locked by default. That can be changed with arguments though. If you use something like a PHP loop to export every table on it's own, the risk is that one table is written to while the PHP script is exporting another, thus leaving you with un-synced data. That might not be a risk, depending on what your database structure is... Mike Gustav Wiberg skrev:

Hi there! Is it neccessary to lock-tables when backing up MySQL-databases? Why? Best regards /Gustav