[root@napmail01 tmp]# mysqlcheck -u root baruwa baruwa.archive OK baruwa.auth_group OK baruwa.auth_group_permissions OK baruwa.auth_hosts OK baruwa.auth_message OK baruwa.auth_permission OK baruwa.auth_user OK baruwa.auth_user_groups OK baruwa.auth_user_user_permissions OK baruwa.celery_taskmeta OK baruwa.celery_tasksetmeta OK baruwa.deliveryinfo OK baruwa.django_content_type OK baruwa.django_session OK baruwa.djcelery_crontabschedule OK baruwa.djcelery_intervalschedule OK baruwa.djcelery_periodictask OK baruwa.djcelery_periodictasks OK baruwa.djcelery_taskstate OK baruwa.djcelery_workerstate OK baruwa.domain_signatures OK baruwa.lists OK baruwa.mail_hosts OK baruwa.mailq OK baruwa.message_recipients OK baruwa.messages OK baruwa.profiles OK baruwa.quarantine_releases OK baruwa.report_filters OK baruwa.sa_rules OK baruwa.scanner_config OK baruwa.scanner_config_sections OK baruwa.scanners OK baruwa.signature_imgs OK baruwa.south_migrationhistory OK baruwa.user_addresses OK baruwa.user_signatures OK
2012/2/28 Jeremy McSpadden <[email protected]> > Looks like its not ok. Have you checked the db? > > > to server failed, using backup > > > -- > Jeremy McSpadden > > On Feb 28, 2012, at 4:01 PM, "Kleber Rocha" <[email protected]> wrote: > > 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 > > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > >
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
