Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

Thanks in advance.

share|improve this question
2  
So, what exactly did you try and what errors did you get? "no one work" is vague. –  ypercube Mar 27 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 at 11:15
1  
You should change the TYPE= to ENGINE= –  ypercube Mar 27 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 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 Mar 27 at 11:40
show 3 more comments

1 Answer 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.

share|improve this answer
add comment

Your Answer

 
discard

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.