[Suggestion] MySQL restore

[GrZeCh]

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

[Official Moderator]

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.

[GrZeCh]

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.

[Official Moderator]

@GrZeCh Currently, recovery for MySQL is not supported. We submitted the Feature request to our Product team. We sincerely appreciate your insight because it helps us to build a better product. 

[GrZeCh]

I can tell you how it works manually or how it works in R1Soft / Idera backup software (basically it is the same way). I can do it here or in some ticket.

[Official Moderator]

@GrZeCh Please, request support from NAKIVO web interface to send a new support bundle and create a ticket on NAKIVO support team. Thank you in advance!