MySQL 4.1 - > 4.0 2006-02-25 - By Ed Wilts
Back
I'm trying to migrate a Drupal database from one ISP to another. The
source is running MySQL 4.1 on taroon 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 " ???????????"
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@(protected)
Member #1, Red Hat Community Ambassador Program
--
Taroon-list mailing list
Taroon-list@(protected)
https://www.redhat.com/mailman/listinfo/taroon-list
|
|
