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.

I can manually edit all the pages that are now corrupted but that's a
lot of effort that I'm hoping to avoid.  I have shell access on both
systems so I can do whatever I need to do to the files after the export
or before the import.  I'm doing the export with mysqldump.

Any suggestions from MySQL experts out there?

Thanks,
        .../Ed

-- 
Ed Wilts, RHCE
Mounds View, MN, USA
mailto:ewilts at ewilts.org
Member #1, Red Hat Community Ambassador Program