Hello,

I am trying to restore some data from the binary log but I get the 
following error:
"Duplicate entry '1' for key 1"

I understand restoring data is a two-stage process:

1. You do a "source myfile.sql" to restore the data saved with mysqldump
2. You restore the data logged in the binary log using mysqlbinlog

I am having the above problem at the second stage and what's more, I 
don't understand how mysql is supposed to know from what point to start 
the restore from.

Thanks in advance,

Balteo.


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to