MySQL 4.1 - > 4.0 2006-02-26 - By Ed Wilts
Back
On Sun, Feb 26, 2006 at 12:31:30PM -0500, Tom Sightler wrote:
> On Sat, 2006-02-25 at 22:38 -0600, Ed Wilts wrote:
>
> > 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.
>
> I'm not a MySQL expert, and I can imaging there are a multiple ways to
> do what your asking (such as using iconv to convert the character set of
> the exported MySQL 4.1 data before importing into MySQL 4.0) however,
> before going any further I'm curious if you are using the documented
> method for exporting from 4.1 to 4.0 at the following URL:
>
> http://dev.mysql.com/doc/refman/4.1/en/downgrading-to-4-0.html
Thanks Tom. I did manage to get it working after my posting. I used
--quote-names --opt --compatible mysql40 and that all worked. I just
couldn't find that --compatible switch documented anywhere with my
googling. The man page for mysqldump didn't have it listed either.
My new web site is on the air now.
Thanks again,
.../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
|
|
