On Sun, Feb 26, 2006 at 08:14:00AM -0600, Ed Wilts wrote:
> I'm trying to migrate a Drupal database from one ISP to another. The
> source is running MySQL 4.1 on taroon (RHEL 3) and the target is MySQL
> 4.0 on taroon.
>
> During the import on 4.0 , I get the error that 'DEFAULT CHARSET=latin1'
> is unsupported. I've googled and googled and the common suggestion is
> to simply delete the phrase and let the data be imported without it.
> Yes, it imports, but some of the pages don't translate properly any
> more. For example, a page with the 3/4 text symbol now appears as
> "¾â€\235" and similarly copyright symbols are mangled.
Following up my posting, the answer is to run mysqldump with the
--compatible mysql40 option. This is not documented in the manpage.
.../Ed
--
Ed Wilts, RHCE
Mounds View, MN, USA
mailto:ewilts at ewilts.org
Member #1, Red Hat Community Ambassador Program