Hi Jon, > Jorge Bastos wrote: > > John & Paul, > > > > To recreate the complete cache, can i: > > > > --- > > Delete from dbmail_header; > > Delete from dbmail_headername; > > Delete from dbmail_headervalue; > > Delete from dbmail_envelope; > > > > Dbmail-util -by > > > Yes - delete from all 4 tables. Do take your daemons down while doing > this to be from cache pollution and client pulling bogus data. I don't > see anything wrong with your db schema that we haven't corrected. > > use dbmail-util -tuby twice to make sure all is well.
To continue this matter, I was checking the table structure, and, are you sure I can delete from dbmail_header? It has some connections by foreign keys, data won't be deleted from the other tables and consequently I'll lose data? The same goes for dbmail_envelope. Or should I do before this: SET FOREIGN_KEY_CHECKS=0; After: SET FOREIGN_KEY_CHECKS=1; ? Jorge, _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
