topic Re: issue with restoring mysql databases in Data Protection

issue with restoring mysql databases

Klaus_InterCity — Wed, 04 Jun 2025 21:34:34 GMT

Hi,

I have a problem with restoring mysql databases. The backup with SnapCreator runs without any errors or warnings and also the restore do so. But when I delete one table in one database after the backup and then restore everything, this table is still missing.

I don't know what to do now and hope someone here could help me. I'm using a Windows Server 2008 R2 mashine with a MySQL 5.7 server, both 64 bit. The SnapCreator agent also runs there.

Please see my config file below. The reason why I left the app name empty is because the SnapCreator won't unquiesce itself. So I use the commands manually.

Thanks for any help!

Re: issue with restoring mysql databases

Jeff_Yao — Thu, 14 Apr 2016 01:03:42 GMT

hi,

see if this tr helps

http://www.netapp.com/us/media/tr-3657.pdf

To restore the database from file-restore, you'd better have the database in LUN.

recommendation is to store each database in separate volume and try volume-restore.

Re: issue with restoring mysql databases

Klaus_InterCity — Thu, 14 Apr 2016 09:07:15 GMT

Hi,

I found one solution for me. Know I'm using the Snap Creator without the MySQL plugin with sdcli commands for consistent snapshots and only the Snap Drive mmc for restoring. By using the Snap Creator for restoring the system always crashed because the Snap Creator disconnect the LUN everytime the restore finnished. So Windows was very angry when one of the hard drives suddenly got lost.

Now everything is running fine but it tooks a lot of time trying the possiblities out.