From: "rik onckelinx" <mailinglists@stripped>
> where "FULLTEXT" was causing the error. My workaround was renaming (in the
sql
> create table scirpt)
>
> fulltext -> ful_text
> option -> optio_
The easiest solution to preventing these errors from popping up from time to
time is to put backticks (`) around names of databases, tables and
columns... INSERT INTO `fulltext` SET (...) ; SELECT * FROM `insert`.`from`
WHERE (...)
PHPMyAdmin uses this also.
You can tell mysqldump to include these quotes with the option -Q :
--quote-names, -Q
Quote database, table, and column names within ``' characters. If the server
SQL mode includes the ANSI_QUOTES option, names are quoted within `"'
characters. As of MySQL 4.1.1, --quote-names is on by default, but can be
disabled with --skip-quote-names.
Regards, Jigal.
