Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Results 1 to 7 of 7
  1. #1
    Member
    Join Date
    Aug 2008
    Location
    India
    Posts
    172

    Cool need help importing large 1gb db :(

    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

  2. #2
    Member
    Join Date
    Nov 2008
    Posts
    76

    Default

    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.
    Regards,
    Jay J,
    HostingZoom | ResellerZoom |
    modVPS

  3. #3
    Member
    Join Date
    Aug 2008
    Location
    India
    Posts
    172

    Cool

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

  4. #4
    Support Manager cPanelEric's Avatar
    Join Date
    Nov 2007
    Location
    Texas
    Posts
    452
    cPanel/Enkompass Access Level

    Root Administrator

    Default

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

  5. #5
    Member
    Join Date
    Jul 2006
    Posts
    285

    Default

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

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

  6. #6
    Member
    Join Date
    Aug 2008
    Location
    India
    Posts
    172

    Cool

    Quote Originally Posted by cpanelerice View Post
    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

  7. #7
    Support Manager cPanelEric's Avatar
    Join Date
    Nov 2007
    Location
    Texas
    Posts
    452
    cPanel/Enkompass Access Level

    Root Administrator

    Default

    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.

Similar Threads & Tags
Similar threads

  1. Trouble importing large MySQL database
    By taylordouglas in forum Data Protection
    Replies: 0
    Last Post: 05-17-2010, 04:46 AM
  2. Importing large MYSQL database
    By greenchicken in forum Database Discussions
    Replies: 3
    Last Post: 04-26-2006, 09:41 PM
  3. Mysql error importing large db
    By Don7t in forum Database Discussions
    Replies: 2
    Last Post: 01-10-2005, 10:09 PM
  4. Logs - How large is large?
    By tntmom5 in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 02-25-2004, 11:29 PM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube