From: Fajar Priyanto
Date: May 27 2004 8:54am
Subject: Re: error restoring and dumping
List-Archive: http://lists.mysql.com/mysql/166247
Message-Id: <200405271554.10988.fajarpri@arinet.org>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thursday 27 May 2004 02:56 pm, Victoria Reznichenko wrote:
> OPTION is a reserved word in MySQL:
> 	http://dev.mysql.com/doc/mysql/en/Reserved_words.html
>
> Use backticks to quote column names: `option`.
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=3Densi=
ta
> This email is sponsored by Ensita.net http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
>        <___/   www.mysql.com

Thanks Victoria,
Yes, when I looked into the original mambo's sql, it was backquoted.
And also, my problem was solved by using mysqlhotcopy, so I was by-passing =
the=20
dumping and restoring process, thus the syntax problem.
Thanks again.
=2D --=20
=46ajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org
15:51:05 up 6:16, Mandrake Linux release 9.2 (FiveStar) for i586=20
public key: https://www.arinet.org/fajar-pub.key
=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFAtayykp5CsIXuxqURAleMAJ9kMpq9DbN5MCmh206tZtfk0qOLIQCgtF+b
iiXb2cjfTA64VNeaXWa0DZo=3D
=3DwhxM
=2D----END PGP SIGNATURE-----