On 03/28/2013 11:38 AM, Sergej Pupykin wrote:
>
> Hello,
>
> I accidentally deleted 'date' header from headername table and MUA
> shows current date for all emails now. How can I recover it, for
> example rebuild whole header* tables?
truncate the dbmail_header table and run
dbmail-util -by
which will run quite long if you have a lot of messages.
Fastest way to truncate the dbmail_header table is probably to
drop/create all three header tables to avoid foreign key cascading:
drop table dbmail_headervalue;
drop table dbmail_headername;
drop table dbmail_header;
create table dbmail_header (...);
create table dbmail_headername (...);
create table dbmail_headervalue (...);
in that order;
--
________________________________________________________________
Paul J Stevens pjstevns @ gmail, twitter, skype, linkedin
* Premium Hosting Services and Web Application Consultancy *
www.nfg.nl/[email protected]/+31.85.877.99.97
________________________________________________________________
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
