Error restoring MySQL database - MySQLD executable not found!
Symptom
When restoring a mySQL database, you may encounter the following error:
Failed to start temporary database instance
MySQLD executable not found! (Path: (deleted) /usr/sbin/mysqld)
Cause
The CDP agent is unable to determine the path to the mysqld binary. This can occur when MySQL is updated but not restarted following the updates. The agent reads information about the reported MySQL pid to get the path to the mysqld binary. In some cases, after updates are applied, the information read by the agent is no longer current.
Example: (Assuming the pid is reported by MySQL as 12345)
root@mysql# ls \-ld /proc/12345/exe
lrwxrwxrwx 1 root root 0 Jan 01 00:00 /proc/12345/exe \-> (deleted)\ /usr/sbin/mysqld
The method that the CDP Agent uses to determine the path to mysqld may change in the future, but for now this is the current method.
Resolution
Restart MySQL to refresh the pid information.
Re-try the restore.
Related Articles
| Page: MySQL 5.5.10 - Unable to Find any Databases During Replication (Knowledge Base) Labels: mysql, database, backup |
| Page: Restoring Large Number of MySQL Databases (Knowledge Base) Labels: mysql |
| Page: Error restoring MySQL database - MySQLD executable not found! (Knowledge Base) Labels: mysql, database, restore |
| Page: MySQL 5.5.10 - Unable to Find any Databases During Replication (Knowledge Base) Labels: mysql, database, backup |
| Page: Error restoring MySQL database - MySQLD executable not found! (Knowledge Base) Labels: mysql, database, restore |
| Page: Database Disk Image Malformed (Knowledge Base) Labels: database, disk, image, malformed, disksafe, hardware, faults |
| Page: How To - Restore the Server Backup Manager H2 Database from backup (Knowledge Base) Labels: h2, internal, database |
| Page: Bare-Metal Restore from an Encrypted Disk Safe (Knowledge Base) Labels: bmr, bare_metal_restore, encryption, encrypted, restore, disk_safe, encryption_key |
| Page: GPT Support and Bare Metal Restore (Knowledge Base) Labels: gpt, livecd, fdisk, labels, bare, metal, restore, bmr |
| Page: Error restoring MySQL database - MySQLD executable not found! (Knowledge Base) Labels: mysql, database, restore |