Bug #8196 Do backup - restore gives error
Submitted: 29 Jan 2005 18:08 Modified: 30 Jan 2005 5:33
Reporter: Michael Taggart Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version:1.0.19 OS:Windows (Windows Server 2003)
Assigned to: CPU Architecture:Any

[29 Jan 2005 18:08] Michael Taggart 
Description:
I can do a full backup of my database and it completes successfully.  When I try to do a restore it get a few records into the restore and gives me an error 'mysql error Nr.0-'  I'm not sure what that means.
I searched the forums and noticed there were a few other posts about this too and no replies for a fix.  In this case I backuped up the full database but only wanted to restore one table.  This was a test to make sure the backup worked reliably.

How to repeat:
Try backing up a full database and then doing a restore on one table.  The table I'm attempting restore is very simple - one column with an index, one column with varchar(45), Datetime, and timestamp.
[29 Jan 2005 21:46] mike wilson 
prob the same as bug #7385
[30 Jan 2005 5:33] Aleksey Kishkin 
http://bugs.mysql.com/bug.php?id=7385