Devart Forums

I'm using TMyBackup to perform the backup process, it work good. But when i restore the database using TMyBackup, it not allowed me to do that. Any good suggestion?

P/S: I'm not going to use TMyDump since it will take quite long time to generate a SQL script (My current database one of the table contain more than 400,000 records! I tried backup, and takes me 40 mins...)

What error message do you have on it? You should correctly set user rights and so on. See http://dev.mysql.com/doc/mysql/en/RESTORE_TABLE.html

Thanks for your information.
The problem still the same, when I'm trying to restore. The error message popup : "error runningnumber - table exists, will not overwrite on restore"

I need to overwrite it, but Throught the link you gave to me, it say that
if you try to restore over an existing table, you will get an error.

I also tried to set the TMybackup's Duplicates property as bdReplace, but same error occurred... help... Thanks!!

Call DROP for corresponding tables before Restore operation.