Jump to content
NAKIVO Community Forum

[Suggestion] MySQL restore


Recommended Posts

Hello,

can you consider creating some kind of MySQL DB restore functionality? I would love to have this kind of mechanism which is creating .sql file or it is restoring DB from backup to new selected DB.

Thanks

  • Like 1
Link to comment
Share on other sites

Hello, @GrZeCh, thank you for your patience during our investigation. Please try to run File level recovery or Universal object recovery - in this case, you will have full access to the backup VM filesystem. You will be able to restore separate files/folders (including database). Then let us know if it will work for you. We are looking forward to hearing from you.

Link to comment
Share on other sites

When it comes to MySQL it is not so simple like it is on MSSQL. On MSSQL you can recover .mdf and .ldf and just attach this DB to any other compatible MSSQL engine. When it comes to MySQL it is not so simple. To recover MySQL DB you will have to access to not only DB dir but also innodb logs, mysql DB (main DB in MySQL engine), performance_schemat DB too.

Investigate it on your end to fully understand whole complexity of this operation. Bottom line just like I said this is not so simple.

  • Like 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...