Re: [newbie] error dumping and restoring mysql

2004-05-27 Thread Fajar Priyanto
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 27 May 2004 01:21 pm, Fajar Priyanto wrote: Got answer from mysql list: 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

[newbie] error dumping and restoring mysql

2004-05-26 Thread Fajar Priyanto
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I'm trying to move my Mambo (content management) database from one server into another. In the old server, the mysql version is 4.0.13, while in the new one it's 4.0.15. The error was when restoring: ERROR 1064 at line 141: You have an erro