On Tuesday 21 September 2004 12:32 pm, Jeffrey Lee wrote: > Hi all, > > I've a mail server which I've installed qmail1.03 with vpopmail-5.2.1, > MySQL 3.23 and qmailadmin. All email users are stored in MySQL's vpopmail > database (in vpopmail.vpopmail table). Yes, 1 table for all users in > different domains. Now, I am migrating everything to another machine. > > On that machine, I've installed netqmail, vpopmail 5.4 and MySQL 4.0. > Everything goes fine. But in the final stages, I need to migrate all user > accounts with their passwords, sql tables, domains and their "leave mail on > servers' mails" to the new machine. I can't find any docs about migration, > backup and restore to a new server. Can anyone help me? I am installing > everything on RedHat's Fedora Core 2.
couple ways you could do it: vconvert -m -c to convert the mysql-based info to cdb format. stop mysql and copy the database directory over to the new server. either way, you'll probably want to use rsync to move the actual mail data over. It will help you get the least amount of downtime (most migrations I do have about 2 minutes of downtime) and (hopefully) allow you to seamlessly migrate between the systems. -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 815.776.9465 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail GnuPG Key ID: 481BF7E2 ++ scriptkitchen.com/kitchen.asc
pgpbwaSaq44pW.pgp
Description: PGP signature