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: [EMAIL PROTECTED] > Cel: 514 918-3350 > > > > > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail -- Jesse Norell - [EMAIL PROTECTED] Kentec Communications, Inc.
