PHPMyAdmin - Nothing happens when 'Go' is clicked.

Discussion in 'Databases' started by Plutonic, Dec 21, 2009.

0
  1. #1
    I'm trying to upload a database using PHPMyAdmin - I choose the file to upload and press "go" and absolutely nothing happens.

    I paste it into the SQL queries box (after a lot of work and freezing because it is huge) and click "go" and nothing happens.

    Are there any other ways to add it that work?

    Thanks.
     
    Plutonic, Dec 21, 2009 IP
  2. Grit.

    Grit. Well-Known Member

    Messages:
    1,424
    Likes Received:
    22
    Best Answers:
    1
    Trophy Points:
    110
    #2
    How long are you waiting for this to go? I mean since you've stated it's a lot of data, it could take a while to upload all that data. Allow it a bit of time...

    BTW, is this on paid hosting? If so, ask your hosting company for a hand since they'll be able to offer the best solution for their configuration
     
    Grit., Dec 21, 2009 IP
  3. Plutonic

    Plutonic Peon

    Messages:
    2,964
    Likes Received:
    85
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Well, when I click 'go' the page loading thing spins for about two seconds, then it stops, like the page is fully loaded. So waiting wouldn't matter, because it's not doing anything.

    And yeah it's paid, but the support I get from them is useless. I have to wait weeks for them to reply, and then they don't even know how to fix it xD
     
    Plutonic, Dec 21, 2009 IP
  4. aap

    aap Well-Known Member

    Messages:
    1,802
    Likes Received:
    39
    Best Answers:
    2
    Trophy Points:
    120
    #4
    Problem can be because of MYSQL version.

    Try deleting following lines from SQL file and execute the SQL query in phpmyadmin.

    
DEFAULT CHARSET = utf8
    Code (markup):
     
    aap, Dec 21, 2009 IP
  5. Prophet Echo

    Prophet Echo Peon

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Contact your webhost, there was a update for phpmyadmin with the latest cpanel update and if they dont co-involve one another, it will cause it to stop working.
     
    Prophet Echo, Dec 21, 2009 IP
  6. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #6
    What is the size of file you are uploading?
     
    mwasif, Dec 27, 2009 IP
  7. wolfeden

    wolfeden Member

    Messages:
    42
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #7
    I am no database wizard but I have uploaded quite a few databases.

    1.st make sure your database is backed up before you try adding to it.

    If you have Cpanel access try this.
    Zip your contents into a .tar file and go into your Cpanel and use your restore wizard to restore that file to your database. Make sure your database settings are already established, D.B name, D.B. user name and password. Make sure to give your username full user permissions. If this is a fresh install, it may work better then you think. But you do have to have the database set up before you try to load it.

    I have a couple sites with large SQL files and sometimes this is the only way I can get them to load.
     
    wolfeden, Dec 29, 2009 IP
  8. zro

    zro Peon

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    Try to get your bd by the command line

    
mysql -h IPHOST --user=user_name --password=pass_word dbname< bd.sql
    Code (markup):
     
    zro, Jan 3, 2010 IP