That makes a lot of sense. Sorry if anything got confused from my end. I'm trying to clean up our database and delete all mail older than 30 days old, but nothing I do seems to free up any space or make any difference to the size that I see on our Amazon RDS page.
Maybe I'm not completely understanding the dbmail-util command's purposes or capabilities? I need to get these databases cleaned as soon as possible because we're getting closer and closer to having to increase the size above 100gb. -----Original Message----- From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On Behalf Of Paul J Stevens Sent: Tuesday, January 21, 2014 10:17 AM To: DBMail mailinglist Subject: Re: [Dbmail] Dbmail-util functionality problems Wait a minute! If you don't have a messageblks table, just do *NOT* run dbmail-util -M -M is meant to migrate content from messageblks to mimeparts. Not relevant in your case. On 21-01-14 16:14, Paul J Stevens wrote: > It's a know bug. I wrote earlier: > > > Definitely a bug. Until it's fixed, just fetch the table DDL from > somewhere and add it to the database. > > http://git.dbmail.eu/paul/dbmail/tree/sql/mysql/create_tables.mysql?h= > dbmail_2_2#n158 > > > > > On 21-01-14 15:39, Gray, Patrick wrote: >> mysql> select distinct(physmessage_id) from dbmail_messageblks limit >> mysql> 10000; >> ERROR 1146 (42S02): Table 'dbmail.dbmail_messageblks' doesn't exist >> >> So I got that... but I have no clue why dbmail_messageblks doesn't exist.. >> >> Could it have been a problem with migration when I upgraded from >> dbmail-3.0..2 to 3.1.7? I checked that .mysql file and it doesn't seem to >> have anything in it concerning dbmail_messageblks. >> >> -----Original Message----- >> From: dbmail-boun...@dbmail.org [mailto:dbmail-boun...@dbmail.org] On >> Behalf Of Paul J Stevens >> Sent: Saturday, January 18, 2014 10:27 AM >> To: DBMail mailinglist >> Subject: Re: [Dbmail] Dbmail-util functionality problems >> >> On 16-01-14 20:40, Gray, Patrick wrote: >> >>> Error:[db] db_query(+361): failed query [SELECT DISTINCT(physmessage_id) >>> FROM dbmail_m essageblks LIMIT 10000] >> >> Again, try to replay above query - minus the spaces: >> >> >> SELECT DISTINCT(physmessage_id) FROM dbmail_messageblks LIMIT 10000; >> >> and see if it gives you a decent error, if any. >> > > -- ________________________________________________________________ Paul J Stevens pjstevns @ gmail, twitter, github, linkedin * Premium Hosting Services and Web Application Consultancy * www.nfg.nl/i...@nfg.nl/+31.85.877.99.97 ________________________________________________________________ _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
