[nycphp-talk] Data import from MySQL 3.23 to MySQL 4.0
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!
Systems Administrator / Developer
More information about the talk