Return
-
Title
Failed to restore MySQL database -
Description
Failed to restore MySQL database
Binary Log
Trace logs
2 MYSQLIF ??? 12617 491 0 52222545093 GetDatabaseDirectoryOwner: Database - 'test', UID - 1001, GID - 10012 MYSQLRES ??? 12617 856 0 52222545210 Failed to drop table 'infile_test' before restoring it.2 MYSQLRES ??? 12617 1014 0 52222545096 Function DropTableBeforeRestoration() starts0 MYSQLIF ??? 12617 495 0 52222545094 GetDatabaseDirectoryOwner returned TRUE.2 MYSQLIF ??? 12617 489 0 52222545085 GetDatabaseDirectoryOwner: Got data directory '/BiO/mysql/data/'.2 MYSQLIF ??? 12617 490 0 52222545087 GetDatabaseDirectoryOwner: Got database directory '/BiO/mysql/data/test'.0 MYSQLIF ??? 12617 460 0 52222545083 character set successfully changed to latin1ace logs
2 MYSQLIF ??? 12617 491 0 52222545093 GetDatabaseDirectoryOwner: Database - 'test', UID - 1001, GID - 10012 MYSQLRES ??? 12617 856 0 52222545210 Failed to drop table 'infile_test' before restoring it.2 MYSQLRES ??? 12617 1014 0 52222545096 Function DropTableBeforeRestoration() starts0 MYSQLIF ??? 12617 495 0 52222545094 GetDatabaseDirectoryOwner returned TRUE.2 MYSQLIF ??? 12617 489 0 52222545085 GetDatabaseDirectoryOwner: Got data directory '/BiO/mysql/data/'.2 MYSQLIF ??? 12617 490 0 52222545087 GetDatabaseDirectoryOwner: Got database directory '/BiO/mysql/data/test'.0 MYSQLIF ??? 12617 460 0 52222545083 character set successfully changed to latin1 -
Cause
Incorrect permission for the user id used during restore
-
Resolution
Noticed the user account does not have the required permission for the database .
After granting all permissions for the respective user account restore job completed successful