0

I have mysql dump file named booster.dump. It was export from 4.0.27-standard mysql server. Now I want to convert this database to mysql 5.1.73-cll. How can I do it? I search about this topic in internet and I have got a lots of solution but no one work for me.

Improve this question
8
  • 2
    So, what exactly did you try and what errors did you get? "no one work" is vague.
    – ypercubeᵀᴹ
    Commented Mar 27, 2014 at 10:29
  • I try to emport my existing dump file to mysql5 and I got this error msg. ` You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM' at line 8`
    – Md. Sahadat Hossain
    Commented Mar 27, 2014 at 11:15
  • 1
    You should change the TYPE= to ENGINE=
    – ypercubeᵀᴹ
    Commented Mar 27, 2014 at 11:17
  • And I thought that TYPE was deprecated only in 5.1 and removed in 5.5 It should only give you a warning, not error.
    – ypercubeᵀᴹ
    Commented Mar 27, 2014 at 11:24
  • 1
    @FloDoe MySQL docs indicate that in 5.1.7 the TYPE was removed and then reallowed (but still deprecated) again in 5.1.8. It was finally removed in 5.5
    – ypercubeᵀᴹ
    Commented Mar 27, 2014 at 11:40

1 Answer 1

Reset to default
1

You can do the following on a Linux system:

sed 's/TYPE=/ENGINE=/g' booster.dump > booster_sane.dump and afterwards import the booster_sane.dump. If you don´t care about your original file you can also make the changes inplace before importing: sed -i 's/TYPE=/ENGINE=/g' (or specify a suffix to -i option to make a backup on the fly).

The reason for your error is explained in the comments to your question.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.