Data Backup and Recovery

issue with restoring mysql databases

Klaus_InterCity
2,396 Views

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!

1 ACCEPTED SOLUTION

Klaus_InterCity
2,343 Views

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.

View solution in original post

2 REPLIES 2

Jeff_Yao
2,352 Views

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.

Klaus_InterCity
2,344 Views

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.

Public