RE: what causes this error [solved. thanks mysql list]
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:dman@dman.ddts.net]
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 debian-user-request@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
Reply to: