[thelist] mysqldump syntax error?

Canfield, Joel JCanfield at PacAdvantage.org
Wed May 3 15:56:50 CDT 2006


> mysqldump --opt --add-locks --add-drop-table --complete-insert
> --lock-all-tables -hDBHOST -uDBUSER -pDBPASS --databases mydb | gzip >
> /path/to/backups/mydb.gz 

hmmm . . . that 'lock all tables' option seems like it would, well, lock
all the tables ;)

i'll bet if our switch couldn't write call records to the database I'd
be in trouble

think i'll have to pursue testing of this kind of query after hours

thanks



More information about the thelist mailing list