-----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=ensita
> 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
dumping and restoring process, thus the syntax problem.
Thanks again.
- --
Fajar Priyanto | Reg'd Linux User #327841 | http://linux.arinet.org
15:51:05 up 6:16, Mandrake Linux release 9.2 (FiveStar) for i586
public key: https://www.arinet.org/fajar-pub.key
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
iD8DBQFAtayykp5CsIXuxqURAleMAJ9kMpq9DbN5MCmh206tZtfk0qOLIQCgtF+b
iiXb2cjfTA64VNeaXWa0DZo=
=whxM
-----END PGP SIGNATURE-----
