MySQL Forums
Forum List  »  Partitioning

Export/Import with table partitioning
Posted by: tempman tempman
Date: August 10, 2022 11:56AM

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...

Options: ReplyQuote


Subject
Views
Written By
Posted
Export/Import with table partitioning
80
August 10, 2022 11:56AM


Sorry, only registered users may post in this forum.

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.