Skip to end of metadata
Go to start of metadata

MySql Restore Fails With Internal Error ./var/lib/mysql/mysql/db.frm Not Found

Symptom:

When attempting to restore MySQL databases using the MySQL Add-On module in version 2.9 of theCDP Server, the following error is generated:

2008-07-17 10:52:57,005 FATAL: (tid:325934) Internal error: (./lib/mysql/MYDB/MYTABLE.frm) not found com.r1soft.util.ServerException: (./lib/mysql/MYDB/MYTABLE.frm) not found at com.r1soft.backup.server.fs.Rk.Rb(Rk.java:207) at com.r1soft.backup.server.task.worker.Rr.doWork(Rr.java:112) at com.r1soft.backup.server.task.RestoreDBTask.executeTask(RestoreDBTask.java:115) at com.r1soft.backup.server.task.Task.tryExecuteTask(Task.java:256) at com.r1soft.backup.server.task.Task.run(Task.java:207) Caused by: com.r1soft.backup.server.fs.FsException: (./lib/mysql/european_europe/agents.frm) not found at com.r1soft.backup.server.fs.Rf.Rb(Rf.java:35) at com.r1soft.backup.server.fs.Rk.Rb(Rk.java:195)

Cause:

R1Soft has acknowledged this issue as a known bug in version 2.9 of the CDP Server.

Resolution:

This issue has been fixed in CDP Server version 2.11 and newer. Before upgrading, please consider KB article #128 regarding agent compatibility for the 2.11 release.

Current Workaround:

For emergency restores, and cases where an upgrade is not feasible, it is possible to restore these database files from the file browser. The MySQL AddOn is necessary to make sure that the MySQL data that we are backing up is consistent, but we are still backing up the databases at the filesystem level. To manually restore these tables, browse the DiskSafe to find these three files for the database you want to restore:

MYTABLE.frm MYTABLE.myd MYTABLE.myi

Check the boxes next to the files to be restored, and select the File Restore option. That should get things back up and running. If you have any questions, please contact the R1Soft Technical Support team at http://support.r1soft.com.

Related Articles

Page: Agent shows a MySQL Error in the logs about MYHELPER (Archived Knowledge Base 2.0) Labels: mysql, install, cdp_server
Page: MySql Restore Fails With Internal Error db.frm Not Found (Archived Knowledge Base 2.0) Labels: mysql, 2-11-release
Page: An IO Error Occurred While Parsing MySQL XML Document (Archived Knowledge Base 2.0) Labels: mysql, xml
Page: MySQL Agent Errors - dots in table filenames (Archived Knowledge Base 2.0) Labels: mysql
Page: License Upgrade Question (Archived Knowledge Base 2.0) Labels: upgrade, license, add-on, mysql
Page: Configuring MySQL instances running inside Virtuozzo VPS (Archived Knowledge Base 2.0) Labels: mysql, add-on, vps, buagent, h/w, node
Page: Restoring MySQL Fails (Archived Knowledge Base 2.0) Labels: mysql
Page: Failed to Start Database r1backup (Archived Knowledge Base 2.0) Labels: mysql
Page: How Do I Add a New MySQL Instance? (Archived Knowledge Base 2.0) Labels: mysql
Page: MySQL Add-on Locks Up MySQL or Backup Hangs During MySQL (Archived Knowledge Base 2.0) Labels: mysql
Page: MySQL Addon - Why MySQL Backups are Not Safe Without It (Archived Knowledge Base 2.0) Labels: mysql
Page: I Have CDP Server Installed - Can I Order MySQL Agent Add-On? (Archived Knowledge Base 2.0) Labels: mysql, license
Page: Enabling MySQL Add-On (Archived Knowledge Base 2.0) Labels: mysql, license
Page: Not having UTF8 set on older mysql servers no longer stops the backup (Archived Knowledge Base 2.0) Labels: mysql
Page: If MySQL backup fails, task state is set to error (Archived Knowledge Base 2.0) Labels: mysql
Page: Added support for innodb_file_per_table (Archived Knowledge Base 2.0) Labels: mysql
Page: Adding MySql Addon for Virtuozzo MySql Instance (Archived Knowledge Base 2.0) Labels: mysql, virtuozzo
Page: Do I Need Root Password of MySQL Database? (Archived Knowledge Base 2.0) Labels: mysql
Page: Is It Safe To Backup MySQL Without Lock And Flush? (Archived Knowledge Base 2.0) Labels: mysql
Page: Can I Restore MySQL Without Having MySQL Agent Add-on Installed? (Archived Knowledge Base 2.0) Labels: mysql
Page: MySQL - Fix permission errors seen in some environments during InnoDB restore (Archived Knowledge Base 2.0) Labels: mysql
Page: MySQL - Fix timeout error during large InnoDB restore (Archived Knowledge Base 2.0) Labels: mysql
Page: MySQL Backup (Archived Knowledge Base 2.0) Labels: mysql
Page: Recovering a Running MySQL Server (Archived Knowledge Base 2.0) Labels: mysql, restore
Page: MySQL Backup Error In Logs (Archived Knowledge Base 2.0) Labels: mysql, backup_error
Showing first 25 of 27 results
Page: cPanel — R1Soft Icon Missing (Archived Knowledge Base 2.0) Labels: cpanel, 2-11-release, 1-49-release
Page: MySql Restore Fails With Internal Error db.frm Not Found (Archived Knowledge Base 2.0) Labels: mysql, 2-11-release
Page: Agent Protocol Version Is Incompatible (Archived Knowledge Base 2.0) Labels: 2-11-release
Page: License Key Warnings — Invalid Feature (0xECEBE6EF) (Archived Knowledge Base 2.0) Labels: license, 2-9-release, 2-11-release, 1-51-release
Page: Log All Files And Folders Successfully Restored (Archived Knowledge Base 2.0) Labels: 2-11-release, log
Labels:
mysql mysql Delete
2-11-release 2-11-release Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.