CODEWITHSUNDEEP
mysqldatabase
Emma
Emma

Reputation: 31

How can I convert a MySQL database into an older version?

How can I convert a MySQL database into an older version MySQL 5.1.48 - > 5.1.46?

Upvotes: 1

Views: 6700

Answers (3)

Mchl
Mchl

Reputation: 62387

Safest way: use mysqldump to dump on 5.1.48 and load on 5.1.46. If you only use MyISAM, you can copy the contents of your /data directory.

Might I ask why downgrading?

Upvotes: 0

Rahul TS
Rahul TS

Reputation: 1218

you can use NAVICATs, navicat for mysql the best tool available in the market. Very simple and quick.

first you have to download the trail version. Its enough to get this done. connect the navicat with the database with newer version then you have to export the content as CSV format, as the second step you have to import the csv file to the older version of mysql by connecting it with navicat,

http://www.navicat.com/en/download/download.html if you cant get it work with the trail try to get an original copy. If you have any doubts regarding this then plz feel free to contact me, I will help you

Upvotes: 1

Mitch Dempsey
Mitch Dempsey

Reputation: 39899

Just export the database using mysqldump and that will give you an SQL file. You can then import that file into your other database server.

Upvotes: 0

Related Questions