[rt-users] Error 1062 at line 11

[Jesse Vincent]

On the candidate box, you need to:

mysqladmin drop rt2
mysqladmin create rt2

before doing the import.  be forewarned that this will IRREVOCABLY TOAST 
all tickets in the database on that host.


On Fri, Dec 21, 2001 at 01:45:25PM -0600, Raymond Norton wrote:
> I have done a mysqldump from one RT server, tried to import it into a new RT
> server, and get the following:
> ERROR 1062 at line 11: Duplicate entry '1' for key 1.
> 
> I know it has something to do with existing data, and can see from my
> reading that there should be a way around this, but I don't want to mess
> anything up by ignorance. I will continue to try and find an answer, but any
> help would be appreciated.
> 
> Here is what I used from a previous posting by someone else trying to do the
> same.
> 
> mysqldump -c -t rt2 >   rt2.sqldump
> mysqldump -d rt2 >       rt2.sqlschema
> You can then restore the whole lot (assuming a fresh install of rt2
> thereafter) with
> mysql rt2  < rt2.sqlschema
> mysql rt2  < rt2.sqldump
> (with whatever usernames and passwords you have specified).
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
http://www.bestpractical.com/products/rt  -- Trouble Ticketing. Free.