convert mysql dump from 4.1 to 3.23

Posted on 2006-04-20
Last Modified: 2012-06-27
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.
Question by:ravenpl
    LVL 8

    Expert Comment


    There is no CHARSET support in 3.x, IIRC. Remove the phrase "DEFAULT CHARSET=latin2" and see whether the query is successful or not.
    LVL 14

    Accepted Solution

    use the "compatible" option of mysqldump : mysqldump --compatible=mysql323
    LVL 43

    Author Comment

    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?)
    LVL 43

    Author Comment

    Found it by myself: --default-character-set=latin2

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    I have been using r1soft Continuous Data Protection ( for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
    Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now