MySQL Database Restoration Expert Needed

Job ID: 38702035

Budget: $30 – $250 AUD

I am experiencing issues with restoring a MySQL database and need an expert to assist with the following tasks:

MySQL Server Configuration:

The MySQL service is failing to start after attempting to restore .ibd files from a backup directory.
The MySQL error log reports issues with tablespaces and foreign key constraints.
We are also dealing with AppArmor restrictions potentially causing MySQL startup problems.
Tasks:

Diagnose and resolve MySQL startup failures, including issues with tablespaces and foreign key constraints.
Properly restore the MySQL .ibd files from a backup directory and re-import tablespaces.
Configure and resolve AppArmor conflicts with MySQL (disabling or fixing permissions as needed).
Verify the integrity of the restored MySQL database and ensure all tables are accessible.
Provide clear documentation and guidance on how the issues were fixed.
Requirements:

Extensive experience with MySQL, InnoDB, and handling .ibd files.
Strong knowledge of Linux server administration, especially with Ubuntu.
Familiarity with AppArmor and MySQL interaction on Ubuntu systems.
Ability to troubleshoot and resolve foreign key constraint issues in MySQL.
Experience with restoring and managing large MySQL databases in production environments.
Deliverables:

Fully restored and operational MySQL database.
Configured MySQL and server environment free of conflicts.
Documentation of the steps taken to resolve the issues.
Related categories: PHP Linux SQL MySQL Database Administration