Re: Upgrading from 3.23.57 to 4.1.9 using mysqldump

Hello. Try --complete-insert command line option for mysqldump. See: http://dev.mysql.com/doc/mysql/en/mysqldump.html [EMAIL PROTECTED] 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

RE: Upgrading from 3.23.57 to 4.1.9 using mysqldump

'Y','Y','Y'),. .. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 10 February 2005 12:08 > To: mysql@lists

Upgrading from 3.23.57 to 4.1.9 using mysqldump

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`