I changed server and when i restore DB, i get error

[edukaris]

Hello guys,

Is there a hosting expert who can help me retire DB successfully?

I changed my server and when migrating files and DB from one Cpnel to another, i got a lot of errors.

So, instead of doing Cpanel to Cpanel migration, i backed all files and Db, downloaded and then uploaded them in the new server.

But then i still got errors.

Is there genuinely a person who can help without destroying my files or corrupting my Db. Kindly.

 

[seomajster]

Hi, in export check "Compatibility mode" to MySQL 4.
Or when you use MySQL 8, then help make a VPS with free aaPanel and create a MySQL 8 external database.

When these 2 tips not work, you can try these more:
https://stackoverflow.com/questions/29916610/1273-unknown-collation-utf8mb4-unicode-ci-cpanel

 

[webmastermedian]

Or use MySQL Workbench to export/import database MySQL,
Navicat for MariaDB.

 

[alexhost]

Maybe your database got corrupted? You don't have any backup?

We can help you to migrate to us, but if your files are corrupted this might be issue, unless you have a backup then we can help you to migrate.

 

[biotipk]

Just ask for a cpmove file from your "old" provider and share the cpmove file with the "new" provider to restore it. 100% safe.

 

[seomajster]

I try migrate database with whole system, fatal crash, never start again

 

[opolo]

Hello guys,

Is there a hosting expert who can help me retire DB successfully?

I changed my server and when migrating files and DB from one Cpnel to another, i got a lot of errors.

So, instead of doing Cpanel to Cpanel migration, i backed all files and Db, downloaded and then uploaded them in the new server.

But then i still got errors.

Is there genuinely a person who can help without destroying my files or corrupting my Db. Kindly.

Whats error? check both database use same engine(mariadb or mysql).
Remove all table from db and import again.
If problem not solve, import db on localhost and then export seperately tables and import each one

 

[edukaris]

Whats error? check both database use same engine(mariadb or mysql).
Remove all table from db and import again.
If problem not solve, import db on localhost and then export seperately tables and import each one

Thank you, problem was solved. I really appreciate the feedback.

 

[opolo]

Thank you, problem was solved. I really appreciate the feedback.

Your welcome. Good luck