Why this happens? Feb 28 07:14:17 napmail01 MailScanner[30376]: Baruwa: Sending message 102DEAC33CA.A8F82 to server failed, using backup Feb 28 07:14:17 napmail01 MailScanner[30376]: Baruwa: 102DEAC33CA.A8F82: Logged using backup DB
The MySQL server is ok and running. Thanks 2012/2/28 Mikael Syska <[email protected]> > http://baruwa.org/docs/batteries_included.html#database-maintenance > > mvh > Mikael Syska > > On Tue, Feb 28, 2012 at 9:47 PM, Kleber Rocha <[email protected]> wrote: > > 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 > > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
