convert mysql dump from 4.1 to 3.23

I have a database dump made on server 4.1, but I need to load it to 3.23.
How to do it? How to convert it?
If I try just load it it fail on line
) ENGINE=MyISAM DEFAULT CHARSET=latin2; --from create table

but there are possibly more failing cases.
LVL 43
ravenplAsked:
Who is Participating?
 
psadacCommented:
use the "compatible" option of mysqldump : mysqldump --compatible=mysql323
0
 
KennyTMCommented:
Hi.

There is no CHARSET support in 3.x, IIRC. Remove the phrase "DEFAULT CHARSET=latin2" and see whether the query is successful or not.
0
 
ravenplAuthor Commented:
psadac: that's great. Points assured.
But, do You know what about charsets conversions? 3.23 has no idea about utf8 (or I'm wrong?)
0
 
ravenplAuthor Commented:
Found it by myself: --default-character-set=latin2
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.