need help importing large 1gb db :(

[bhanuprasad1981]

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]

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.

[bhanuprasad1981]

tried more than eight times
1. delete data base
2. create date base
3. try to import
4. see same error

[cPanelEric]

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).

[ChrisRHS]

For importing large DB's, its best to use the command line:

mysql dbname < /path/to/file.sql -u user --password=pass

[bhanuprasad1981]

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

[cPanelEric]

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.