# 10.0.17-MariaDB migration to Percona Server 5.7 **URL:** \ **Category:** Other MySQL® Questions\ **Created:** [October 31, 2016, 2:16am UTC](https://forums.percona.com/t/10-0-17-mariadb-migration-to-percona-server-5-7/5180 "2016-10-31T02:16:23Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![mmajaJoker](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mmajajoker/32/1143_2.png) [@mmajaJoker](https://forums.percona.com/u/mmajaJoker)\ **Post date:** [October 31, 2016, 2:16am UTC](https://forums.percona.com/t/10-0-17-mariadb-migration-to-percona-server-5-7/5180/1 "2016-10-31T02:16:23Z")
we wanna migration database mariadb to percona server (10.0.17-MariaDB migration to Percona Server 5.7) can just replace basedir using percona server? and mysql\_upgrade or should mysqldump all data , and source to percona server ---
**Author:** ![mmajaJoker](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mmajajoker/32/1143_2.png) [@mmajaJoker](https://forums.percona.com/u/mmajaJoker)\ **Post date:** [February 20, 2017, 2:48am UTC](https://forums.percona.com/t/10-0-17-mariadb-migration-to-percona-server-5-7/5180/2 "2017-02-20T02:48:25Z")
10.0.17-MariaDB upgrade to Percona Server 5.7 can using percona server mysql\_upgrade? ---
**Author:** ![Ofir\_Granot](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ofir_granot/32/2585_2.png) [@Ofir\_Granot](https://forums.percona.com/u/Ofir_Granot)\ **Post date:** [October 10, 2021, 5:15am UTC](https://forums.percona.com/t/10-0-17-mariadb-migration-to-percona-server-5-7/5180/3 "2021-10-10T05:15:30Z")
I got a similar request, I need to migrate MariaDB 10.0.30 to Percona Server 5.7, can anyone assist with this question please? Another 2 questions please: should I migrate MariaDB 10.0.30 to Percona 5.6 first and then upgrade to 5.7? can I use xtrabackup full backup of MariaDB 10.0.30 and restore into a Percona server Thank you, Ofir ---
**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\ **Post date:** [October 13, 2021, 11:16am UTC](https://forums.percona.com/t/10-0-17-mariadb-migration-to-percona-server-5-7/5180/4 "2021-10-13T11:16:29Z")
Hi folks, MariaDB 10 is based on MySQL 5.5, so you cannot directly upgrade to Percona 5.7 (cannot skip major versions). In addition to this, MariaDB 10 has some additional features, and the code base started to diverge so you cannot do a direct replacement of binaries or physical backup. My recommendation is to use [mydumper](https://github.com/maxbube/mydumper/releases) to perform a logical backup/restore for the purpose of the migration. ---
**Author:** ![Ofir\_Granot](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ofir_granot/32/2585_2.png) [@Ofir\_Granot](https://forums.percona.com/u/Ofir_Granot)\ **Post date:** [March 20, 2022, 8:45am UTC](https://forums.percona.com/t/10-0-17-mariadb-migration-to-percona-server-5-7/5180/5 "2022-03-20T08:45:14Z")
Hello, After migrating from MariaDB 10.0 to percona 5.7 (using mysqldump) the percona slave failed to replicate from the MariaDB 10.0 on the following temporal column format error: Last\_SQL\_Error: Could not execute Write\_rows\_v1 event on table schema.table; Incorrect datetime value: ‘S204-70-12 20:09:60.000’ for column ‘column’ at row 1, Error\_code: 1292; Corrupted replication event was detected, Error\_code: 1610; handler error No Error!; the event’s master log server001-bin.000023, end\_log\_pos 100260 What is the differences between mydumper to mysqldump (besides of efficiency and performance for big DBs)? I already reviewed and aware of the temporal columns format issue, What is the best approach to migrate from mariadb 10.0 to percona when I need to preserve the old temporal columns format for the replication to success? because when using mysqldump (and similar tools such mydumper) it creates new tables and it have the new temporal columns format. Not sure if there is a way to replicate from mariadb 10.0 to percona 5.5/5.6 when preserving the columns format, xtrabackup does not support migration between mariadb and percona ---
**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\ **Post date:** [March 21, 2022, 2:15pm UTC](https://forums.percona.com/t/10-0-17-mariadb-migration-to-percona-server-5-7/5180/6 "2022-03-21T14:15:41Z")
Using mysqldump in this case won’t work because tables in 5.7 will get created with the new date/time format. You will need to restore the dump in a 5.6 release, then upgrade it to 5.7 (use mysql\_upgrade -s to avoid upgrading non-system tables). After that replication _should_ work. Keep in mind this is not a supported scenario though.