SQL Database Upgrade and Migration

I need an experienced backend developer to migrate, upgrade, and clean up my MySQL database so that my redesigned website can be imported successfully to a Hostinger live server. The original site runs on PHP 5.7/MySQL 5.7; the redesign was built locally on PHP 8.2/MySQL 8.2. The SQL dump currently fails due to:

* A malformed table name (missing underscore in wrd_customcontact_forms_field_options)
* ERROR 1062 (23000): Duplicate entry '1' for key 'PRIMARY' on primary-key inserts

Key Requirements:
- Migrate the existing MySQL 5.7 database to MySQL 8.2
- Correct malformed table names and schema inconsistencies in the SQL dump
- Resolve duplicate-key conflicts (e.g. by truncating tables, using INSERT IGNORE or upserts)
- Optimize database performance and indexing post-migration
- Ensure data integrity and security throughout the process
- Collaborate with frontend developers to verify seamless integration with the redesigned PHP 8.2 site

Ideal Skills and Experience:
- Deep expertise in MySQL (5.7 → 8.x upgrades) and SQL schema design
- Proven track record of database migrations, error troubleshooting, and performance optimization
- Familiarity with PHP/MySQL hosting environments (e.g. Hostinger, Flywheel)
- Strong understanding of backup strategies, data validation, and security best practices
- Clear communication and documentation skills

Please provide examples of similar work done and your approach to tackling these performance issues.