-----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 > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ 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----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
