List:General Discussion« Previous MessageNext Message »
From:ars k Date:June 19 2009 7:52pm
Subject:Re: Duplicate key name when importing mysql dump file
View as plain text  
Hi Jason,
You may have to run "ANALYZE TABLE.." for the particular table for which you
are facing the error. So it'll rebuild the indexes. This would be the best
one to save your data.

We can use the method which Mr.Isart suggested, but it'll ignore the error
and also will lead to data loss.

Regards,
Vinodh.k


On Sat, Jun 20, 2009 at 12:19 AM, Isart Montane <isart.montane@stripped>wrote:

> Hi Jason,
>
> if you run mysql with -f it will ignore any errors and continue importing
>
> cat aac.sql | mysql -f -u root AAC
>
> Isart
>
> On Wed, Jun 17, 2009 at 8:59 PM, Jason Novotny <jason.novotny@stripped
> >wrote:
>
> >  Hi,
> >
> >   I'm trying to import a dumpfile like so:
> >
> > cat aac.sql | mysql -u root AAC
> >
> > It all runs fine until I get something like:
> >
> > ERROR 1061 (42000) at line 5671: Duplicate key name
> 'FK_mediaZip_to_zipSet'
> >
> >
> > Is there a way I can tell it to ignore or replace the key?
> >
> > Thanks, Jason
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=1
> >
> >
>

Thread
Duplicate key name when importing mysql dump fileJason Novotny17 Jun
  • Re: Duplicate key name when importing mysql dump fileIsart Montane19 Jun
    • Re: Duplicate key name when importing mysql dump filears k19 Jun