mysql fails to execute sqlyog batch script

[virgil]

I'm running MySQL 4.0.16 and SQLyog 3.71. I export a database to sql scripts using SQLyog, and then try to execute the sql batch script with the mysql.exe command line tool. I get the “ERROR 1049” problem, as mysql chokes on the single quoted object names. (My workaround is to remove all the offending quotes so it will execute).

This is not a db version compatibility issue, as I am trying to execute on the same server I exported from.

Also, I do not have the option of executing the sql scripts from SQLyog. These are to be distributed with an application that needs to set up its initial db via an installer.

Any suggestions?

— Andy

[Ritesh]

Can you tell me the complete error message?

Quote:

Also, I do not have the option of executing the sql scripts from SQLyog.

Use Tools -> Execute Batch File…

[virgil]

Ritesh wrote on Jul 1 2004, 06:34 PM:

Use Tools -> Execute Batch File…

But I have no problem with that, it works fine. The problem is executing the sqlyog-generated sql using mysql.exe. The error message from that tool is:

Code:

ERROR 1049 at line 10: Unknown database '`junkdb`'

Thanks,

— Andy

[virgil]

Oh — what I meant by “I don't have the option…” is not that I can't find it in the menu, but that my customers will not have sqlyog. Sorry for the confusion.

[virgil]

I am still suffering from this problem — is this a known problem? It seems MySQL will not grok the backquotes that sqlyog generates, and that perhaps sqlyog parses them (or somehow eats them) before executing the statements.

[Ritesh]

This is strange. Can you mail me the SQL file? I will ask my development team to work on it.

[Author]

Posts