mysql locking and backups

[niall at kst.com (Niall Kavanagh)]

Just to clarify the back scenario. If using mysqldump doesn't suit your
needs, you lock the tables and then perform the file backup. Once the lock
has been released the inserts will take effect.

Again, you can work around it if you feel mysql is meeting you needs by
using temporary tables while the lock is in place. A kludge, but it works.

Chances are pretty good if you're using mysql in a production enviornment
you value read access over write anyway. If that's not the case, us
postgreSQL.

Perhaps we should have a mysql/postgreSQL demostration sometime?

--
Niall Kavanagh, niall at kst.com
News, articles, and resources for web professionals and developers:
http://www.kst.com

-
Subcription/unsubscription/info requests: send e-mail with
"subscribe", "unsubscribe", or "info" on the first line of the
message body to discuss-request at blu.org (Subject line is ignored).