problem changing server

Discussion in 'Databases' started by adamk1, Feb 5, 2008.

  1. #1
    Hi

    I am having a problem downloading my sql database for vbulletin with PHPmyadmin as it is 120MB I have tried bits of software without success dont know what else to try does anybody have any Ideas?
     
    adamk1, Feb 5, 2008 IP
  2. shallowink

    shallowink Well-Known Member

    Messages:
    1,218
    Likes Received:
    64
    Best Answers:
    2
    Trophy Points:
    150
    #2
    You don't have command line access? If not, ask your host to export it to a file for you.
     
    shallowink, Feb 5, 2008 IP
  3. LittleJonSupportSite

    LittleJonSupportSite Peon

    Messages:
    386
    Likes Received:
    20
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Be a little more specific of the problem.

    If you login via phpMyadmin then create the database.

    Now click the SQL tab.

    Paste your .sql dump into the Query window.

    What errors(if any) does it return?

    I have seen the LATIN COL etc etc error a bunch of times because of ISAM type.

    but you literally chop that off the end and it will import just fine.

    Post your error logs. I would say post the .sql but it probably contains sensitive data.
     
    LittleJonSupportSite, Feb 5, 2008 IP
  4. redinlove

    redinlove Peon

    Messages:
    216
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #4
    you have ssh acces ?
     
    redinlove, Feb 5, 2008 IP
  5. selvamurali

    selvamurali Peon

    Messages:
    69
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    no need it use bigdump its very easy man., if u need help ask me
     
    selvamurali, Jul 27, 2011 IP