Not the answer you need?
Register and ask your own question!

Innobackupex from 5.5 to 5.6

amitamit EntrantCurrent User Role Beginner
Hi

Are there known issues when using Innobackupex on Percona MySQL 5.5 and restore it in Percona MySQL 5.6. We are seeing date change when data was moved using Innobackupex. Not sure if it is safe to use innobackupex with version change

Percona MySQL 5.5 | 84 | Medical | NULL | NULL | 0000-00-09 04:59:40 | 9902-04-16 24:00:00 | | 85 | Supplies | NULL | NULL | 0000-00-09 04:59:40 | 9902-04-16 24:00:00 | +----+
+
+
+
+
+ Percona MySQL 5.6 | 84 | Medical | NULL | NULL | 2013-01-09 21:30:22 | 2013-01-09 21:30:22 | | 85 | Supplies | NULL | NULL | 2013-01-09 21:30:22 | 2013-01-09 21:30:22 | +----+
+
+
+
+
+

Comments

  • SQLGuySQLGuy Contributor Current User Role Beginner
    I would think that would be very risky, if it would work at all. Remember that the databases would be at an old version, and the data dictionary and system tables would be at another. The best and safest way to do that kind of upgrade is to use mysqldump.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.