That is one way. You may also have it the upper limit of your auto_increment.
-- Jeremy McSpadden Flux Labs, Inc http://www.fluxlabs.net<http://www.fluxlabs.net/> Endless Solutions Office : 850-588-4626 Cell : 850-890-2543 Fax : 850-254-2955 From: Kleber Rocha <[email protected]<mailto:[email protected]>> Reply-To: Baruwa list <[email protected]<mailto:[email protected]>> Date: Tue, 28 Feb 2012 17:47:25 -0300 To: Baruwa list <[email protected]<mailto:[email protected]>> Subject: Re: [Baruwa] Duplicate Entry I understanding the export, but how can I archive messages tables, to avoid that table growing? Rename table and create new table with the properties of old table? Thanks 2012/2/28 Jeremy McSpadden <[email protected]<mailto:[email protected]>> mysqldump –uUSER –pPASSWORD DBNAME > /tmp/backup.sql Login to mysql drop database DBNAME; create database DBNAME; Logout mysql –uUSER-pPASSWORD DBNAME < /tmp/backup.sql Problem you'll run out of memory real quick doing this import. 24gb db file .. good luck with that -- Jeremy McSpadden Flux Labs, Inc http://www.fluxlabs.net<http://www.fluxlabs.net/> Endless Solutions Office : 850-588-4626<tel:850-588-4626> Cell : 850-890-2543<tel:850-890-2543> Fax : 850-254-2955<tel:850-254-2955> From: Kleber Rocha <[email protected]<mailto:[email protected]>> Reply-To: Baruwa list <[email protected]<mailto:[email protected]>> Date: Tue, 28 Feb 2012 17:37:44 -0300 To: Baruwa list <[email protected]<mailto:[email protected]>> Subject: Re: [Baruwa] Duplicate Entry I don't understanding, I have to create dump? how can I export this table? Thanks 2012/2/28 Jeremy McSpadden <[email protected]<mailto:[email protected]>> Export and start over :) -- Jeremy McSpadden On Feb 28, 2012, at 2:34 PM, "Kleber Rocha" <[email protected]<mailto:[email protected]>> wrote: How can I archive this? Thanks 2012/2/28 Jeremy McSpadden <[email protected]<mailto:[email protected]>> You can't. Unless you want to go ID by ID .. And manually delete them. I'm pretty sure you'll have more than a few. Why is your DB 24gb? Why don't you archive the database -- Jeremy McSpadden On Feb 28, 2012, at 2:25 PM, "Kleber Rocha" <[email protected]<mailto:[email protected]>> wrote: Jeremy, Thanks for the reply. But this table has 24GB, how can I avoid this issue? Thanks. 2012/2/28 Jeremy McSpadden <[email protected]<mailto:[email protected]>> Export the table, then reimport. Will re-index on import. -- Jeremy McSpadden On Feb 28, 2012, at 2:02 PM, "Kleber Rocha" <[email protected]<mailto:[email protected]>> wrote: > Hi, > > I have many errors like: > > Duplicate entry '7AF82AC3AF1.A5D3F' for key 'PRIMARY' error 1062 recorded: > Duplicate entry '7AF82AC3AF1.A5D3F' for key 'PRIMARY' > > > How can I fix this? > > Thanks > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056 _______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
