On Sun, 07 Apr 2002 00:55:59 -0500
Balteo <[EMAIL PROTECTED]> wrote:
> 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.
The error means that a "query" from mysqlbinlog file consist a key that already exists
on your database.
what is your method in order to restoring from binary log ? maybe we can help you to
get through :D
--
Let's call it an accidental feature.
-- Larry Wall
---------------------------------------------------------------------
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
