MySQL Forums
Forum List  »  Newbie

Re: Trouble importing old .sql files
Posted by: Peter Brawley
Date: August 05, 2020 12:55PM

> I was asking about converting the .sql dump
> file (like converting an old .doc file to .docx)

As you said, you're "migrating a MySQL 4.19 system to an 8.15 (or 8.21) system". That's not like converting an old Word file.

The likelihood of success loading a .csv import file into a MySQL instance of another version diminishes the further away that version is, and once it loads, you'll still need to regression-test the db to find the problems. MySQL supports moving by one major version at a time: you import, regression-test, fix problems, export ... then repeat for each major version till you reach your target.

Options: ReplyQuote


Subject
Written By
Posted
Re: Trouble importing old .sql files
August 05, 2020 12:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.