1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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