This was the error for the record. Thanks debian list. justin Okay, now the problem is clear. mysqladmin 3.23.37 uses backticks (`) around the database names (as you can see in the error message you quoted) to support special chars therein, but backticks for quoting column/table/database names where only intrudcued in 3.23.6, so the 3.22.32 server doesn't know about them and issues an syntax error.
AFAICS, you have the following options: - type the commands yourself and don't use backticks (i.e. use the mysql client and issue a "CREATE DATABASE test2") - upgrade the server to at least 3.23.6 (of course you would want a more recent release) - downgrade the mysqladmin client to the distribution of at most 3.23.5 (of course, you would rather want the latest 3.22.x client) - compile mysqladmin yourself and change the CREATE DATABASE statement accordingly -----Original Message----- From: dman [mailto:[EMAIL PROTECTED] Sent: Thursday, May 30, 2002 7:06 PM To: debian-user@lists.debian.org Subject: Re: what causes this error On Thu, May 30, 2002 at 01:26:24PM -0700, justin cunningham wrote: | mysqladmin: CREATE DATABASE failed; error: 'You have an error in your | SQL syntax near 'whateverunamethedatabase' How about including the offending SQL as well? WHen there's a coding error and the code isn't shown, one can only guess. -D -- I tell you the truth, everyone who sins is a slave to sin. Now a slave has no permanent place in the family, but a son belongs to it forever. So if the Son sets you free, you will be free indeed. John 8:34-36 GnuPG key : http://dman.ddts.net/~dman/public_key.gpg -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
