MySQL Forums
Forum List  »  InnoDB

Re: How to reduce ibtmp1 file in mysql 5.7?
Posted by: Peter Brawley
Date: April 11, 2016 11:42AM

Looks like a botched upgrade.

For upgrades across major versions, we're supposed to mysqldump existing data, install the new version, then load the dump file script into the new installation instead of trying to reuse existing data files and folders. The installer often forces this issue by ignoring the current defaults-file and datadir settings, thus hiding existing data from the new installation.

You didn't do this? You just ran mysql_upgrade? How did you persuade 5.7 to use 5.6 data?

Have you tried running mysql_upgrade again?

To redo the upgrade, you'd need a 5.6 data backup and a binary log of what's changed since the upgrade. You have neither? Fixing this mess will be a slog.

What is the result of ...

select * from mysql.plugin;

Options: ReplyQuote

Written By
Re: How to reduce ibtmp1 file in mysql 5.7?
April 11, 2016 11:42AM

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.