Re: Duplicate key name when importing mysql dump file

2009-06-19 Thread ars k
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. Rega

Re: Duplicate key name when importing mysql dump file

2009-06-19 Thread Isart Montane
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 wrote: > Hi, > > I'm trying to import a dumpfile like so: > > cat aac.sql | mysql -u root AAC > > It all runs fine unti