need help importing large 1gb db :(

bhanuprasad1981

Well-Known Member
Aug 5, 2008
222
0
66
India
i got a new client , he wants me to transfer site manually i copied files to new account issue is with Db he gave me a dump of mysql as it is very large 1gb+ in size i copied it to my server and tried import using ssh but it is stopping at 229 mb with error :-

Column count doesn't match value count at row 2589


please help me to solve :(
 

hzJayJ

Well-Known Member
Nov 14, 2008
76
1
58
Hi,

The error specifies that the number of fields and the number of values are different to which you are trying to restore the dump. Try recreating the database and try restoring the .sql file.
 

Eric

Well-Known Member
Nov 25, 2007
752
12
143
Texas
cPanel Access Level
Root Administrator
It sounds like the database file might be messed up in some regard. The only other thing I could think of is if the backup is from a 4.1 or newer and you're running mysql 4.0 or older (which is unlikely).
 

bhanuprasad1981

Well-Known Member
Aug 5, 2008
222
0
66
India
It sounds like the database file might be messed up in some regard. The only other thing I could think of is if the backup is from a 4.1 or newer and you're running mysql 4.0 or older (which is unlikely).

sorry but present version of mysql on my server si :- 5.0.77-community
i have no knowledge of the version dump sql is :(
 

Eric

Well-Known Member
Nov 25, 2007
752
12
143
Texas
cPanel Access Level
Root Administrator
Have you tried importing it to another mysql server? Give it a go on anything else to see if the dump file is bad. (which is what I think it is, personally) Even if you have to install mysql on your desktop to test it out. MySQL rinses clean with a reboot. :D