MySQL Forums
Forum List  »  Install & Repo

Upgrade from 5.1 to 5.7 to 8.x
Posted by: Thomas Jüntgen
Date: April 21, 2020 01:12AM

Hello all,

I tried already 3 days and read a lot of post but I didn't come to the goal.
I use Windows 10 and MyISAM tables.

I tried to upgrade to mysql-5.7.29-winx64.
I come to the problem

[ERROR] InnoDB: The Auto-extending innodb_system data file '.\ibdata1' is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if non-zero) ...

I tried the In_Place Upgrade.
All my file for the database are located on D:\Programme\MySQL\Server

My steps are
1. shut down the MySQL
2. copy all files 5.7.29 to bin directory
3. change the my.ini file in this way
3.1 removed default-character-set and innodb_additional_mem_pool_size
3.2 change table_cache to table_open_cache
3.3 add at the end
innodb_data_home_dir =
innodb_data_file_path = /ibdata1:10M:autoextend
4. mysql -u root -p

and then the prolem starts.

Thanks for your help

Options: ReplyQuote

Written By
Upgrade from 5.1 to 5.7 to 8.x
April 21, 2020 01:12AM

Sorry, only registered users may post in this forum.

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.