Error restoring Bayes Database (MySQL)

[Eric Goforth <er...@goforthtech.com>]

Having a crazy thing happen when trying to restore my Bayes database to a new MySql Server.  
 
During the restore process, it stops with the following error message.  However, it is clearly only partial informaiton as some of the characters must be goofy ascii codes.  The screen jumps around during the restore and dumps this error message:
 
 e 262: Duplicate entry '496-þÌ

I'm hosed if I can't restore my database (for whatever reason and heaven forbid a system failure...)..
 
Anyone have any insight?  Thanks!
 
Eric J. Goforth
eric@goforthtech.com
 
 

Re: Error restoring Bayes Database (MySQL)

["sysadmin@destination.ca" <sy...@destination.ca>]

Hi,

The same problem happen if you try to have amavis database replicated on 
multiple mysql server.

It would be nice to have a way around this and also a way to configure a 
fail over mysql server.

Regards
Cedric

askthelist@gmail.com wrote:
> think i ran into the same problem. try a direct backup from old mysql 
> host to new mysql server. or you can also stop mysql on the old host and 
> tar up the raw files and move them over that way.
> 
> On 4/30/07, *Eric Goforth* <eric@goforthtech.com 
> <ma...@goforthtech.com>> wrote:
> 
>     Having a crazy thing happen when trying to restore my Bayes database
>     to a new MySql Server. 
>      
>     During the restore process, it stops with the following error
>     message.  However, it is clearly only partial informaiton as some of
>     the characters must be goofy ascii codes.  The screen jumps around
>     during the restore and dumps this error message:
>      
>      e 262: Duplicate entry '496-þÌ
>     I'm hosed if I can't restore my database (for whatever reason and
>     heaven forbid a system failure...)..
>      
>     Anyone have any insight?  Thanks!
>      
>     Eric J. Goforth
>     eric@goforthtech.com <ma...@goforthtech.com>
>      
>      
> 
> 

Re: Error restoring Bayes Database (MySQL)

[as...@gmail.com]

think i ran into the same problem. try a direct backup from old mysql host
to new mysql server. or you can also stop mysql on the old host and tar up
the raw files and move them over that way.

On 4/30/07, Eric Goforth <er...@goforthtech.com> wrote:
>
>  Having a crazy thing happen when trying to restore my Bayes database to a
> new MySql Server.
>
> During the restore process, it stops with the following error message.
> However, it is clearly only partial informaiton as some of the characters
> must be goofy ascii codes.  The screen jumps around during the restore and
> dumps this error message:
>
>  e 262: Duplicate entry '496-þÌ
> I'm hosed if I can't restore my database (for whatever reason and heaven
> forbid a system failure...)..
>
> Anyone have any insight?  Thanks!
>
> Eric J. Goforth
> eric@goforthtech.com
>
>
>