Innobackupex from 5.5 to 5.6

MySQL & MariaDB Percona XtraBackup
1

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 | ±—±-------------------±-----------±-----------±--------------------±--------------------+

2

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.