Modify the insert statement so that you name the column you're inserting
to.
INSERT INTO `db` (put the column names in here)
VALUES('localhost','dbxxx','','Y','Y','Y','Y','Y','Y','N','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.mysql.com
> Subject: 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` 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
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
**************************************************************************************
ALCHEMETRICS LIMITED (ALCHEMETRICS)
Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX
Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001
This e-mail is confidential and is intended for the use of the addressee only.
If you are not the intended recipient, you are hereby notified that you must
not use, copy, disclose, otherwise disseminate or take any action based on
this e-mail or any information herein.
If you receive this transmission in error, please notify the sender
immediately by reply e-mail or by using the contact details above and then
delete this e-mail.
Please note that e-mail may be susceptible to data corruption, interception
and unauthorised amendment. Alchemetrics does not accept any liability for
any such corruption, interception, amendment or the consequences thereof.
**************************************************************************************
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
