Hello,
First off, make sure you really need to restore database
dump data -
if the user just deleted some mail they need back, remember
that it's
still in the database, marked with status=2, until it's
cleared out with
a couple runs of dbmail-util.
Assuming you do need to get that data out, you can't
easily do it
right from a mysqldump file. It could be done with a script
that could
parse the file and figure out all of that users mailboxes,
messages,
etc., but it's not a simple option to mysqldump or
anything, and I've
not heard of anyone that's written such a script offhand.
It may be
easier to restore your entire dump to another database name,
and copy
from that (either export the mail to an mbox and re-import
into your
live system, or fire up dbmail-imapd on the
"new" database and use
imapsync to sync the two).
Jesse
On Mon, 2006-04-24 at 10:32 -0400, Jacques Beaudoin wrote:
> Hi,
>
> I have to restore all data for one user.
>
> Does anybody have de mysqldump commands to restore all
data for a user
> from a mysqldump file for dbmail 1.2.11.
>
> If you have de commands for 2.0 I will try to adapt
them to 1.2.11,
>
> and they will also be useful for me, since i'm
upgrading to 2.0.
>
> Thanks
>
> Jacques Beaudoin
> Agent d'administration
> Les services des technologies
> de l'information et des communications
> Commission scolaire de la Pointe de l'Île
> Montréal, Québec, Canada
>
> Courriel/Email: jacques-beaudoin cspi.qc.ca
> Cel: 514 918-3350
>
>
>
>
> _______________________________________________
> Dbmail mailing list
> Dbmaildbmail.org
> htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
--
Jesse Norell - jessekci.net
Kentec Communications, Inc.
_______________________________________________
Dbmail mailing list
Dbmaildbmail.org
htt
ps://mailman.fastxs.nl/mailman/listinfo/dbmail
|