3 messages in com.mysql.lists.mysqlRe: Upgrading from 3.23.57 to 4.1.9 u...
FromSent OnAttachments
Kevin Cowley10 Feb 2005 04:16 
user...@zerbrechlich.de10 Feb 2005 12:07 
Gleb Paharenko10 Feb 2005 23:21 
Subject:Re: Upgrading from 3.23.57 to 4.1.9 using mysqldump
From:Gleb Paharenko (gleb@ensita.net)
Date:02/10/2005 11:21:45 PM
List:com.mysql.lists.mysql

Hello.

Try --complete-insert command line option for mysqldump. See: http://dev.mysql.com/doc/mysql/en/mysqldump.html

user@zerbrechlich.de wrote:

Hi,

I just tried to upgrade from mysql 3.23.57 (SPARC/Solaris) to 4.1.9 (i386/Linux)
using mysqldump but when importing the dump on the new machine mysql gives the
error:

ERROR 1136 (21S01) at line NNN: Column count doesn't match value count at row 1

and in line NNN you find

INSERT INTO `db` VALUES
('localhost','dbxxx','','Y','Y','Y','Y','Y','Y','N','Y','Y','Y'),...

so he is right. The table 'db' has more entries in 4.1.9 than in 3.23.57! But
what is the correct way to upgrade? (NO! It is not possible for me to upgrade
directly on the 3.23.57 machine!)

MANY thanx in advance, Frank