[rt-users] Error 1062 at line 11
jesse at bestpractical.com
Fri Dec 21 17:26:30 EST 2001
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
> 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://www.bestpractical.com/products/rt -- Trouble Ticketing. Free.
More information about the rt-users