Migration failed with MYSql

[ajit]

HI Team,

We are trying to migrate fisheye to a mysql db, but it fails saying problem running drop schema .

We are using version:

• Server version: 5.0.45
• mysql-connector-java-5.1.47-bin.jar
• RHEL 5
• Fisheye 3.5.1
• Database Schema Version 87

[Ajin Aniyan]

That “problem running drop schema” error during Fisheye migration usually happens because of incompatible MySQL versions or missing privileges. Fisheye 3.5.1 is quite old, and MySQL 5.0.45 doesn’t fully support newer JDBC connectors like mysql-connector-java-5.1.47. Try upgrading MySQL to at least version 5.5 or 5.6, or use an older connector version such as mysql-connector-java-5.0.8. Also, make sure the MySQL user has full privileges including DROP, CREATE, and ALTER on the schema. If the migration still fails, it could be due to corruption or incomplete schema objects in the existing database. In that case, you can use third-party tools like Stellar Repair for Mysql to repair and rebuild corrupted frm or ibd files before retrying the migration.

[Shawn Doyle - ReleaseTEAM]

Hi @ajit 

Can you share the procedure you are using for the migration?

From the error, "failed to drop schema", are you sure this isn't in the part where you are exporting from the old DB?

[ajit]

additionally for info :

character_set_system | utf8

collation_server | latin1_swedish_ci