Please help me, im unable to upload sql file to wordpress mysql

Discussion in 'Content Management' started by mixtaka, May 8, 2010.

  1. #1
    Hello

    I have a wordpress site suppose www.A.com i export database of www.A.com from mysql,

    NOW i want to import the database (which is in sql format, 112 MB) of www.A.com to my another wordpress blog suppose you called - www.B.com.

    now im login to mysql server of www.B.com and import the database of www.A.com to www.B.com, after showing process around 30 - 40 minute, im logout automatically to mysql server of www.B.com. and the database did not install.

    can anyone tell me what should i do to install database of www.A.com to www.B.com successfully.

    Thanks
     
    mixtaka, May 8, 2010 IP
  2. AlcVitRes

    AlcVitRes Well-Known Member

    Messages:
    124
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    130
    #2
    Increase script timeout limit or import database part by part.
    Good advice would be to visit this page with details provided.

    Had such issue with DLE DB ower 4*0 MB recently, both ways
    combined works like charm. See chapter #2 of both solutions.
     
    AlcVitRes, May 8, 2010 IP
  3. Serious Workers

    Serious Workers Well-Known Member

    Messages:
    2,785
    Likes Received:
    65
    Best Answers:
    2
    Trophy Points:
    195
    #3
    You can increase it's time or you can break the database in 2 parts.
     
    Serious Workers, May 10, 2010 IP
  4. mixtaka

    mixtaka Active Member

    Messages:
    267
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #4
    how can i break database, is there is any software.
     
    mixtaka, May 10, 2010 IP
  5. mixtaka

    mixtaka Active Member

    Messages:
    267
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    53
    #5
    when i upload sql file in godaddy mysql i got this error

    can anyone tell what should i do

    be understand im completely new in mysql
     
    mixtaka, May 10, 2010 IP