Skip to end of metadata
Go to start of metadata

Restoring MySQL Fails

Symptom


Using the MySQL plug-in, a restore of any MySQL database is failing with:

Internal error: tried to read non-directory as directory

This happens with any combination of paths, alternate restore locations, etc.

CDP Server Stand Alone (Linux)
Version: 2.15.0 build 6935
Parallels Pro (Ensim) server

Cause


This error typically means that the database directory (/var/lib/mysql/database_name) is actually a symbolic link. Our normal file restore method knows how to work around this, but the MySQL module does not.

Resolution


The quick solution is to manually select the necessary tables and use the File Restore. The MySQL restore is simply automating that for you.

Contact R1Soft support to receive an alternate restore method that works in this case.

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
Labels:
mysql mysql Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.