Re: [vchkpw] Moving everything to a new server
On Monday 08 March 2004 12:24 pm, Don Walters wrote: > >~vpopmail/bin/vconvert <-- run that by itself. > > Ok, that helps. Now I guess that means I need to create each domain on the > new server, put this file under each domain (same place as on the old > server) and rerun the command converting everything back to mysql format? > That will update the mysql tables for me? Sounds like you are trying to copy over your mysql database. On the old machine you can dump the vpopmail database with: mysqldump -uroot -p vpopmail > vpopmail.sql On the new machine in mysql command line mysql -uroot -p create database vpopmail; quit Then import the data mysql -uroot -p < vpopmail.sql Ken Jones
Re: [vchkpw] Moving everything to a new server
On Mon, 2004-03-08 at 12:24, Don Walters wrote: > >~vpopmail/bin/vconvert <-- run that by itself. > > > Ok, that helps. Now I guess that means I need to create each domain on the > new server, put this file under each domain (same place as on the old > server) and rerun the command converting everything back to mysql format? > That will update the mysql tables for me? you should just be able to copy the vpopmail/domains directory, along with qmail's control files and users/assign and have it all work. -Jeremy -- Jeremy Kitchen Systems Administrator [EMAIL PROTECTED] Kitchen @ #qmail on EFNet - Join the party! . Inter7 Internet Technologies, Inc. www.inter7.com 866.528.3530 toll free 847.492.0470 int'l 847.492.0632 fax GNUPG key ID: 93BDD6CE
Re: [vchkpw] Moving everything to a new server
~vpopmail/bin/vconvert <-- run that by itself. Ok, that helps. Now I guess that means I need to create each domain on the new server, put this file under each domain (same place as on the old server) and rerun the command converting everything back to mysql format? That will update the mysql tables for me? Sorry for all the Q's. I just want to be sure I'm doing right before I start doing all this work. _ One-click access to Hotmail from any Web page download MSN Toolbar now! http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/
Re: [vchkpw] Moving everything to a new server
On Mon, 2004-03-08 at 12:00, Don Walters wrote: > >I'm no database expert, but you may need to "export" the database to > >some "flat file" format from the old server, then "import" it into the > >new one. > > > Yeah, I've been reading about using "vconvert" to save the mysql database to > cdb format and then import that back into the new server, running the > conversion backwards... like so... > > [EMAIL PROTECTED] # /home/vpopmail/bin/vconvert -m -c > > [EMAIL PROTECTED] # /home/vpopmail/bin/vconvert -c -m > > Problem is... I did the first command and I don't have any idea where the > stuff was written to. it writes it to vpasswd files in each domain's directory, just as if you had used cdb authentication from the start. > Can somebody tell me what all of the options are for vconvert? What > arguments will it take? ~vpopmail/bin/vconvert <-- run that by itself. > What do they do? ~vpopmail/bin/vconvert <-- run that by itself. > Where is the output written? inside each domain's 'home directory' in a vpasswd file. -Jeremy -- Jeremy Kitchen Systems Administrator [EMAIL PROTECTED] Kitchen @ #qmail on EFNet - Join the party! . Inter7 Internet Technologies, Inc. www.inter7.com 866.528.3530 toll free 847.492.0470 int'l 847.492.0632 fax GNUPG key ID: 93BDD6CE
Re: [vchkpw] Moving everything to a new server
On Monday 08 March 2004 12:00 pm, Don Walters wrote: > >I'm no database expert, but you may need to "export" the database to > >some "flat file" format from the old server, then "import" it into the > >new one. > > Yeah, I've been reading about using "vconvert" to save the mysql database > to cdb format and then import that back into the new server, running the > conversion backwards... like so... > > [EMAIL PROTECTED] # /home/vpopmail/bin/vconvert -m -c > > [EMAIL PROTECTED] # /home/vpopmail/bin/vconvert -c -m > > Problem is... I did the first command and I don't have any idea where the > stuff was written to. I tried looking for documentation on vconvert but > the stuff on inter7.com's website is a joke! > > Take a look at their "man pages" for vconvert: > > http://www.inter7.com/vpopmail/doc/vconvert.html > > Can somebody tell me what all of the options are for vconvert? What > arguments will it take? What do they do? Where is the output written? > I'd love to use it if I just knew how! Look in the domain directory. vconvert should create a vpasswd file. Ken Jones
Re: [vchkpw] Moving everything to a new server
I'm no database expert, but you may need to "export" the database to some "flat file" format from the old server, then "import" it into the new one. Yeah, I've been reading about using "vconvert" to save the mysql database to cdb format and then import that back into the new server, running the conversion backwards... like so... [EMAIL PROTECTED] # /home/vpopmail/bin/vconvert -m -c [EMAIL PROTECTED] # /home/vpopmail/bin/vconvert -c -m Problem is... I did the first command and I don't have any idea where the stuff was written to. I tried looking for documentation on vconvert but the stuff on inter7.com's website is a joke! Take a look at their "man pages" for vconvert: http://www.inter7.com/vpopmail/doc/vconvert.html Can somebody tell me what all of the options are for vconvert? What arguments will it take? What do they do? Where is the output written? I'd love to use it if I just knew how! _ One-click access to Hotmail from any Web page download MSN Toolbar now! http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/
[vchkpw] Moving everything to a new server
I would like to move everything from one server to another. I have installed mysql, vpopmail, qmail, and a bunch of other services on the new machine. Now all that remains is moving my vpopmail database over to the new server. Since this database is pretty big, I don't want to create all of those tables again, so I'd like to just copy everything over. I have tried copying over all the stuff from /var/lib/mysql/vpopmail over to the new machine. I have also copied over all the domains under /home/vpopmail/domains, and also copied over the stuff under /var/qmail/control and /var/qmail/users but it's still giving me "vpopmail user not found" errors when I try to authenticate with a mail client. I have run mysql login commands manually to be sure it's not a login problem to the mysql server. The file /home/vpopmail/etc/vpopmail.mysql was also copied over. What am I forgetting? Is there a better (cleaner) way to do this? _ One-click access to Hotmail from any Web page download MSN Toolbar now! http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/