Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread Paul J Stevens
On 02/07/2012 11:31 PM, drsyst...@globalcerts.net wrote: > Hi, > > I looked at how imapsync works, and I don't think I can use it - the > systems will be at different physical locations and they run ssh, and the > database may be too big. But I am not familiar with that tool, so correct > me if I

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread Reindl Harald
Am 07.02.2012 23:31, schrieb drsyst...@globalcerts.net: > Hi, > > I looked at how imapsync works, and I don't think I can use it - the > systems will be at different physical locations and they run ssh, and the > database may be too big. But I am not familiar with that tool, so correct > me if I

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread Paul J Stevens
On 02/08/2012 10:31 AM, Reindl Harald wrote: > > this maybe a much smoother way as export/transfer/import gigabytes > of mysqldumps since it does not interrupt services How does a mysqldump interrupt services?? -- Paul J Stevens

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread Reindl Harald
Am 08.02.2012 10:41, schrieb Paul J Stevens: > On 02/08/2012 10:31 AM, Reindl Harald wrote: >> >> this maybe a much smoother way as export/transfer/import gigabytes >> of mysqldumps since it does not interrupt services > > How does a mysqldump interrupt services?? dumping gigabytes of data take

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread Paul J Stevens
On 02/08/2012 10:56 AM, Reindl Harald wrote: > > > Am 08.02.2012 10:41, schrieb Paul J Stevens: >> On 02/08/2012 10:31 AM, Reindl Harald wrote: >>> >>> this maybe a much smoother way as export/transfer/import gigabytes >>> of mysqldumps since it does not interrupt services >> >> How does a mysqld

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread drsystems
Paul and Reindl, Thank you both for all the information, this will help me to devise a procedure. Dirce > On 02/08/2012 10:56 AM, Reindl Harald wrote: >> >> >> Am 08.02.2012 10:41, schrieb Paul J Stevens: >>> On 02/08/2012 10:31 AM, Reindl Harald wrote: this maybe a much smoother way

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread drsystems
Hi, I am running the script /var/lib/mysql/dbmail[157] mysql < 2_2-3_0.mysql on an old host (test host) that I want to migrate. I get the error: ERROR 1025 (HY000) at line 68: Error on rename of './dbmail/#sql-9dd_357e' to './dbmail/dbmail_users' (errno: 150) I have been fixing it one db at a

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread Reindl Harald
Am 08.02.2012 19:46, schrieb drsyst...@globalcerts.net: > Hi, > > I am running the script > > /var/lib/mysql/dbmail[157] mysql < 2_2-3_0.mysql > > on an old host (test host) that I want to migrate. > > I get the error: > > ERROR 1025 (HY000) at line 68: Error on rename of './dbmail/#sql-9dd_

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread drsystems
Here is more information: from the log file: 120207 09:54:53 mysqld started 120207 9:54:54 InnoDB: Started; log sequence number 0 167636 120207 9:54:54 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.45' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 120

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread drsystems
Here is one of the places where this problem is discussed, but I don't find or understand the workarounds for this. Thanks, Dirce http://www.gossamer-threads.com/lists/dbmail/dev/30854?do=post_view_threaded> > > Am 08.02.2012 19:46, schrieb drsyst...@globalcerts.net: >> Hi, >> >> I am running

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread drsystems
More info: dbmail-mysql-2.2.5-7.fc8.i386 : The DBMail mail storage system Repo: fedora Matched from: Other : dbmail-mysql = 2.2.5-7.fc8 my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock port=3306 max_allowed_packet=16M max_connections=300 I realize you are in

[Dbmail] Best procedure for installing Dbmail from scratch on Ubuntu Server

2012-02-08 Thread Bill Harris
I have a brand new Ubuntu Server VPS, that I'd like to build Dbmail, and Exim on.. Any recommendations on the best recipe? Bill -- ___ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread Paul J Stevens
On 02/08/2012 07:46 PM, drsyst...@globalcerts.net wrote: > Hi, > > I am running the script > > /var/lib/mysql/dbmail[157] mysql < 2_2-3_0.mysql which is incorrect, as you found out already. > ERROR 1025 (HY000) at line 68: Error on rename of './dbmail/#sql-9dd_357e' > to './dbmail/dbmail_users'

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread drsystems
Thanks in advance - here is the information: Old schema: -- MySQL dump 10.11 -- -- Host: localhostDatabase: dbmail -- -- -- Server version5.0.45 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CH

Re: [Dbmail] migrating data from 2.2 to 3.0

2012-02-08 Thread Reindl Harald
the workaround is in the link you posted ALTER TABLE dbmail_sievescripts ADD UNIQUE INDEX dbmail_sievescripts_1 (owner_idnr, name); no idea why your keys are different, my definitions are from fedora summer 2009, however i would generally reccomend exclude all unique-key-changes out of the migra