Page 1 of 1

Backup/Restore MySQL Database

Posted: Mon 15 Nov 2004 08:43
by kenny
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...)

Re: Backup/Restore MySQL Database

Posted: Mon 15 Nov 2004 16:09
by Ikar
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

Posted: Mon 15 Nov 2004 17:00
by kenny
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!!

Posted: Tue 16 Nov 2004 09:10
by Ikar
Call DROP for corresponding tables before Restore operation.