The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

need help importing large 1gb db :(

Discussion in 'General Discussion' started by bhanuprasad1981, Jun 7, 2009.

  1. bhanuprasad1981

    bhanuprasad1981 Well-Known Member

    Joined:
    Aug 5, 2008
    Messages:
    222
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    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 :(
     
  2. hzJayJ

    hzJayJ Well-Known Member

    Joined:
    Nov 14, 2008
    Messages:
    76
    Likes Received:
    1
    Trophy Points:
    8
    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.
     
  3. bhanuprasad1981

    bhanuprasad1981 Well-Known Member

    Joined:
    Aug 5, 2008
    Messages:
    222
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    tried more than eight times :(
    1. delete data base
    2. create date base
    3. try to import
    4. see same error :(
     
  4. Eric

    Eric Administrator
    Staff Member

    Joined:
    Nov 25, 2007
    Messages:
    746
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    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).
     
  5. ChrisRHS

    ChrisRHS Well-Known Member

    Joined:
    Jul 12, 2006
    Messages:
    292
    Likes Received:
    5
    Trophy Points:
    18
    For importing large DB's, its best to use the command line:

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

    bhanuprasad1981 Well-Known Member

    Joined:
    Aug 5, 2008
    Messages:
    222
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India

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

    Eric Administrator
    Staff Member

    Joined:
    Nov 25, 2007
    Messages:
    746
    Likes Received:
    11
    Trophy Points:
    18
    Location:
    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
     
Loading...

Share This Page