Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
So, what exactly did you try and what errors did you get? "no one work" is vague. – ypercubeᵀᴹ Mar 27 '14 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 Mar 27 '14 at 11:15
You should change the TYPE= to ENGINE= – ypercubeᵀᴹ Mar 27 '14 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ᵀᴹ Mar 27 '14 at 11:24
@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ᵀᴹ Mar 27 '14 at 11:40

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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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