Page 1 of 1
Backup/Restore MySQL Database
Posted: Mon 15 Nov 2004 08:43
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
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
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
Call DROP for corresponding tables before Restore operation.