Hi there!
Is it neccessary to lock-tables when backing up MySQL-databases? Why?
Best regards
/Gustav
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php