NYCPHP Meetup

[nycphp-talk] Data import from MySQL 3.23 to MySQL 4.0

Ajai Khattri ajai at bitblit.net
Thu Jan 6 14:34:24 EST 2005


Allen Shaw wrote:

> And, incedentally, if you're using mysqldump to export the data, 
> there's an option to force backticks on table and column names:
>
> |--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|.
>

Good to know - this is a much better way to do the import :-)

Thanks very much!

-- 
Aj.
Systems Administrator / Developer




More information about the talk mailing list