Hi.
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
Bye,
Benjamin.
PS: Of course it would be more compatible, if the 3.23.x mysqladmin
added the backticks only when needed.
>From a private mail from [EMAIL PROTECTED]:
[...]
> oba:~# mysqladmin ver
[...]
> Server version 3.22.32-log
On Thu, May 30, 2002 at 05:12:04PM -0700, [EMAIL PROTECTED] wrote:
> exactly. mysqladmin -V
> mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686
>
[...]
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Benjamin Pflugmann
>
> > This works fine for me. What is the output of
> >
> > mysqladmin -V
> > mysqladmin version
> > On Thu, May 30, 2002 at 03:09:11PM -0700, [EMAIL PROTECTED] wrote:
> > > mysqladmin create test2
> > > mysqladmin: CREATE DATABASE failed; error: 'You have an error in your
> > > SQL syntax near '`test2`' at line 1'
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
