MYSQL alternate instance restore failed with "Failed to restore table/view 'myTable'"
Clicking at "More Info" revealed the following error.
It is due the backup source MYSQL server having the GTID enabled while the restore target MYSQL server not having the GTID enabled.
MYSQL is not able to set GTID related parameters on the restore target MYSQL server, thus the restore failed.
To restore the MYSQL database to alternate instance MYSQL Server, the restore target MYSQL Server needs to also have GTID enabled.
To enable GTID on restore target MYSQL Server, make sure these parameters are being enabled in my.cnf.
log_bin = /var/log/mysql/mysql-bin.log
enforce_gtid_consistency = true
gtid_mode = ON
log_slave_updates
For log_bin directory, please edit to make sure the directory location is valid on the restore target MYSQL Server.
After the changes are being made, restart the MYSQL Server to have GTID enabled.
Performing the restore after that will be successful.
