[thelist] mysqldump syntax error?

[Max Schwanekamp]

> From: Canfield, Joel  
> copied directly from the help files:
>     mysqldump --opt db_name > backup-file.sql
> 
> which I modified to 
>     mysqldump --opt cdrdb > cdr200605.sql
> 
> and I get error 1064 'your syntax sucks'

Wondering if maybe mysqldump is taking part of 'cdrdb' as an argument rather
than as a string for the db name?  Don't have time to peruse the docs right
now, but this is how I do it (via cron), and it seems to work fairly well:
mysqldump --opt --add-locks --add-drop-table --complete-insert
--lock-all-tables -hDBHOST -uDBUSER -pDBPASS --databases mydb | gzip >
/path/to/backups/mydb.gz 

-- 
Max Schwanekamp
http://www.neptunewebworks.com/