RE: [vchkpw] Export one domain from mysql to another
Title: Export one domain from mysql to another You can always run vconvert on the domain and pull the sql stuff down to a cdb file, Then move the files over to the new server and run vconvert again to stuff the domain into the new DB. Mark -Original Message- From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 4:00 PM To: [EMAIL PROTECTED] Subject: [vchkpw] Export one domain from mysql to another Hello guys is there a way to export one domain from my vpopmail (mysql) so I can move it to another server. Thanks,
RE: [vchkpw] Export one domain from mysql to another
Title: Export one domain from mysql to another that will export all the info I have 30 domains and I want only one of them Thanks anyhow. Remo From: Sean C Truman [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 2:04 PMTo: 'Remo Mattei'Subject: RE: [vchkpw] Export one domain from mysql to another man mysqldump Sean From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 3:00 PMTo: [EMAIL PROTECTED]Subject: [vchkpw] Export one domain from mysql to another Hello guys is there a way to export one domain from my vpopmail (mysql) so I can move it to another server. Thanks,
RE: [vchkpw] Export one domain from mysql to another
Title: Export one domain from mysql to another That sound like a lot of pain!!! Remo From: Mark Spieth [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 2:03 PMTo: Remo Mattei; [EMAIL PROTECTED]Subject: RE: [vchkpw] Export one domain from mysql to another You can always run vconvert on the domain and pull the sql stuff down to a cdb file, Then move the files over to the new server and run vconvert again to stuff the domain into the new DB. Mark -Original Message-From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 4:00 PMTo: [EMAIL PROTECTED]Subject: [vchkpw] Export one domain from mysql to another Hello guys is there a way to export one domain from my vpopmail (mysql) so I can move it to another server. Thanks,
RE: [vchkpw] Export one domain from mysql to another
Title: Export one domain from mysql to another Takes 2 seconds [EMAIL PROTECTED] root]# /home/vpopmail/bin/./vconvert -m -c test.com converting test.com test.com done done [EMAIL PROTECTED] root]# /home/vpopmail/bin/./vconvert -c -m test.com converting test.com done -Original Message- From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 4:19 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] Export one domain from mysql to another That sound like a lot of pain!!! Remo From: Mark Spieth [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 2:03 PM To: Remo Mattei; [EMAIL PROTECTED] Subject: RE: [vchkpw] Export one domain from mysql to another You can always run vconvert on the domain and pull the sql stuff down to a cdb file, Then move the files over to the new server and run vconvert again to stuff the domain into the new DB. Mark -Original Message- From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 4:00 PM To: [EMAIL PROTECTED] Subject: [vchkpw] Export one domain from mysql to another Hello guys is there a way to export one domain from my vpopmail (mysql) so I can move it to another server. Thanks,
RE: [vchkpw] Export one domain from mysql to another
Title: Export one domain from mysql to another I have many-domains=y I tried this: mysqldump -p -B vpopmail -t vpopmail -w pw_domain="mastroraphael.com"Enter password: -- MySQL dump 8.23 Host: localhost Database: vpopmail--- Server version 3.23.58 Current Database: vpopmail-- CREATE DATABASE /*!32312 IF NOT EXISTS*/ vpopmail; USE vpopmail; Dumping data for table `dir_control` WHERE: pw_domain=mastroraphael.com mysqldump: Got error: 1054: Unknown column 'pw_domain' in 'where clause' when retrieving data from server butnoluck. Thanks, again, REMO From: Sean C Truman [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 2:22 PMTo: 'Remo Mattei'Subject: RE: [vchkpw] Export one domain from mysql to another Depends on how you have vpopmail configured.. --enable-many-domains=n then it will create a table for every domain. Sean From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 3:18 PMCc: [EMAIL PROTECTED]Subject: RE: [vchkpw] Export one domain from mysql to another that will export all the info I have 30 domains and I want only one of them Thanks anyhow. Remo From: Sean C Truman [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 2:04 PMTo: 'Remo Mattei'Subject: RE: [vchkpw] Export one domain from mysql to another man mysqldump Sean From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 3:00 PMTo: [EMAIL PROTECTED]Subject: [vchkpw] Export one domain from mysql to another Hello guys is there a way to export one domain from my vpopmail (mysql) so I can move it to another server. Thanks,
Re: [vchkpw] Export one domain from mysql to another
Remo Mattei wrote: snip Export one domain from mysql to another I tried this: mysqldump -p -B vpopmail -t vpopmail -w pw_domain="mastroraphael.com" snip -- Dumping data for table `dir_control` -- -- WHERE: pw_domain=mastroraphael.com mysqldump: Got error: 1054: Unknown column 'pw_domain' in 'where clause' when retrieving data from server This would be because you didn't read the mysql dump man page. -t says not to write create info, --tables specifies a table. Also of note, -B is for MULTIPLE databases, not one. butnoluck. Thanks, again, REMO You want: mysqldump -u user -p vpopmail --tables vpopmail -w pw_domain="mastroraphael.com" However the vconvert method other people have suggested looks significantly safer and easier. Also, don't forgot to insure that the path to the user mailbox remains EXACTLY the same on the new box. You'll also want to dump the dir_control table entry for this domain so that vadduser and whatnot create people in the right place. Hope that helps, Nick Harring Webley Systems
Re: [vchkpw] Export one domain from mysql to another
Title: Export one domain from mysql to another I am doing something like this now, it's working great. you can tell vconvert to only do one domain.. You convert to cdb then create the domain on the new server with any old password then you use vconvert to convert the info from the cdb file to mysql. -John - Original Message - From: Remo Mattei Cc: [EMAIL PROTECTED] Sent: Friday, November 21, 2003 1:17 PM Subject: RE: [vchkpw] Export one domain from mysql to another that will export all the info I have 30 domains and I want only one of them Thanks anyhow. Remo From: Sean C Truman [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 2:04 PMTo: 'Remo Mattei'Subject: RE: [vchkpw] Export one domain from mysql to another man mysqldump Sean From: Remo Mattei [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 3:00 PMTo: [EMAIL PROTECTED]Subject: [vchkpw] Export one domain from mysql to another Hello guys is there a way to export one domain from my vpopmail (mysql) so I can move it to another server. Thanks,