开发者

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

开发者 https://www.devze.com 2023-01-15 05:16 出处:网络
How can I convert a MySQL database into an older version MySQL 5.1开发者_Python百科.48 - > 5.1.46?you can use NAVICATs, navicat for mysql the best tool available in the market. Very simple and quick.

How can I convert a MySQL database into an older version MySQL 5.1开发者_Python百科.48 - > 5.1.46?


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


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.


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?

0

精彩评论

暂无评论...
验证码 换一张
取 消