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]> > 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 > Endless Solutions**** > *Office* : 850-588-4626**** > *Cell* : 850-890-2543 > *Fax* : 850-254-2955 > > From: Kleber Rocha <[email protected]> > Reply-To: Baruwa list <[email protected]> > Date: Tue, 28 Feb 2012 17:37:44 -0300 > To: Baruwa list <[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]> > >> Export and start over :) >> >> >> -- >> Jeremy McSpadden >> >> On Feb 28, 2012, at 2:34 PM, "Kleber Rocha" <[email protected]> wrote: >> >> How can I archive this? >> >> Thanks >> >> 2012/2/28 Jeremy McSpadden <[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]> 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]> >>> >>>> Export the table, then reimport. Will re-index on import. >>>> >>>> >>>> -- >>>> Jeremy McSpadden >>>> >>>> On Feb 28, 2012, at 2:02 PM, "Kleber Rocha" <[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
