Export/Import with table partitioning
Hi,
I'm newbie, so I'm sorry. I'm trying migrate a 5.6 mysql database to mariadb (a more new version).
I have a full database backup done (not sure if it's correct with all data). When I do import in target mariadb database all is ok. But I've compared datadir size and it is different. Source is 144MB and target is 84MB, so I've thought that something is bad.
I've compared files with different sizes and I've compared this tables and I've seen that in source DB it has partitions. These partitions are not in target, so I think that it is the problem. What I don't understand is that when I do select count(*) in this tables, it shows same rows in source and target (not sure if in source it is counting partitioned data :-?).
Could someone help me please about how could I export all data and import in mariadb database and all is ok (with partitions)? :-) Thanks beforehand.
Cheers...
Subject
Views
Written By
Posted
Export/Import with table partitioning
1229
August 10, 2022 11:56AM
594
August 10, 2022 01:38PM
534
August 10, 2022 03:00PM
485
August 11, 2022 07:00AM
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.