Error during database migration

Support and Discussion Database Server
1

I would like to migrate my CyberPanel server from a CentOS 7 to an Ubuntu22. When migrating the WordPress database, I get this error message.

image
image960×88 4.54 KB

I assume this is because the MariaDB has different versions.

This is also an excerpt from phpMyAdmin from the existing CentOS 7 server:

image
image661×687 24.9 KB

And this is an excerpt from the new server on Ubuntu:

image
image674×686 42.1 KB

It is also noticeable that the old server does not use Unicode charset.

image
image

But maybe it is also due to the different PHP web servers or phpMyAdmin versions?

Any idea how to clean up the MariaDB? Or how I could upgrade parts of the old CentOS 7 server?

Unfortunately I have tried an upgrade without success. I have described the error in this thread:

2

I was able to solve the problem myself. My WordPress database had apparently become quite cluttered over the years. I didn’t even know that every page change is saved as a “revision” in WordPress. There were also a few problematic ones that had caused trouble during the migration.

There are various database cleaners. The WP-Sweep plugin helped me, for example. My export file dropped from 30 MB to 7 MB after the clean up. You can see how much garbage was in there. :smile: