Upgrading msql from 5.7 to 8.019
Posted by: wesonga (41.90.31.---)
Date: April 07, 2020 06:36AM

Hi, Please help me, how do i upgrade mysql version 5.7.28 to 8.019 i am stack on the way.

Options: ReplyQuote
Re: Upgrading msql from 5.7 to 8.019
Posted by: Otomatic (Moderator)
Date: April 07, 2020 09:02AM

Hi,

The question to ask you is: "Do I absolutely need to upgrade from MySQL 5.7.28 to 8.0.19?"
If it ain't broke DONT FIX IT

Then as indicated here on WAMPserver 3 - All you need to know and on http://wampserver.aviatechno.net :
The only perennial and reliable way to transfer databases between different versions of MySQL or MariaDB should be done by EXPORT/IMPORT of SQL files using phpMyAdmin or similar tool. Do not copy the data folder between different versions of MYSQL or MariaDB. The contents of the data folders of different versions of MYSQL or MariaDB are not compatible! You could destroy the version of MYSQL or MariaDB to which you copied the data folder.

When you have read the text above, it says it all:
- Exporting databases as SQL files under MySQL 5.7.28
- Switch to MySQL 8.0.19
- Import databases under MySQL 8.0.19

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.9 32 bit - Apache 2.4.53 - PHP 8.1.5…5.6.40 - MySQL 5.7.38 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.9 64 bit - Apache 2.4.53 - PHP 8.1.5…5.6.40 - MySQL 5.7.38/8.0.29 - MariaDB 10.5.15/10.7.3
PhPMyadmin 5.1.3 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: Upgrading msql from 5.7 to 8.019
Posted by: wesonga (41.90.31.---)
Date: April 07, 2020 09:36AM

I did export in 5.7.28 as sql files, Then i IMPORTED in8.0.19, BUT i found in my new imported DATABASE some information cannot not be read hence empty information in my SQL reports.(THE IMPORTED SQL REPORTS LACKS INFORMATION OR ARE EMPTY WITHOUT INFORMATION)

Options: ReplyQuote
Re: Upgrading msql from 5.7 to 8.019
Posted by: Otomatic (Moderator)
Date: April 07, 2020 10:22AM

Hi,

Some export parameters are probably missing. See the MySQL documentation on this subject and mainly the differences between 5.7 and 8.0.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.9 32 bit - Apache 2.4.53 - PHP 8.1.5…5.6.40 - MySQL 5.7.38 - MariaDB 10.5.13/10.6.5
Wampserver 3.2.9 64 bit - Apache 2.4.53 - PHP 8.1.5…5.6.40 - MySQL 5.7.38/8.0.29 - MariaDB 10.5.15/10.7.3
PhPMyadmin 5.1.3 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.