Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Blog | Linux Links | Bling | About BLU

BLU Discuss list archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

mysql locking and backups

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

Perhaps we should have a mysql/postgreSQL demostration sometime?

Niall Kavanagh, niall at
News, articles, and resources for web professionals and developers:

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

BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!

Boston Linux & Unix /