[thelist] mysqldump syntax error?

[David Kaufman]

Canfield, Joel <JCanfield at PacAdvantage.org> wrote:
>    mysqldump --opt db_name > backup-file.sql
> 
> which I modified to
> 
>    mysqldump --opt cdrdb > cdr200605.sql
> 
> and I get error 1064 'your syntax sucks'
> 
> tried various other output file names and paths with no joy
>
>> Really.  I've never noticed mysqldump (nor any of the other
>> mysql utilities) to say [that]
> 
> um, i was paraphrasing; error was as you say

Okay, then can you post the actual error message?  Particularly, the part of the command it quotes that that it didn't understand?  That might help some evolteur identify the problem.

Now that i think about it though... Error 1064 (an error in SQL *input*) actually makes no sense when running mysqldump, which doens't *take* sql input, but rather generates its own SQL output... maybe you typed "mysql" by mistake instead of "mysqldump"!

>>> I don't have admin access to the box in question, and probably
>>> can't get it (it's our phone system)
>> 
>> Oh.  Call that phone company, then!
> 
> well, thus far the response has been 'use our handy utility' which
> can't be scheduled, so I'm looking for a workaround

Ah certainly a noble endeavor!

Good luck, 

-dave