[KLUG Members] MySQL migration from 4.0.27 to 5.0.37

[Michael Lueck]

Richard Vincent wrote:
> See if this article helps:
> 
> http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/

No mention of character sets. However:

 >>
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html

--default-character-set=charset_name

Use charset_name as the default character set. See Section 5.10.1, “The Character Set Used for Data and Sorting”. If no character set is specified, mysqldump uses utf8, and earlier versions use latin1.
<<

I may just specify to dump the 4.0.x database using utf8 and see how it goes.

Thanks,

-- 
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/