Uploading MySQL DB to bluehost.com

Discussion in 'Databases' started by Shaimaa, Feb 11, 2010.

  1. #1
    Dear all,

    I want to know how to upload a Database from my PC to hosting site like bluehost.com

    thank you in advance.

    Yours,
    Shaimaa
     
    Shaimaa, Feb 11, 2010 IP
  2. systematical

    systematical Peon

    Messages:
    81
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Does blue host of phpMyAdmin, do they give you shell access?

    Some versions of phpmyadmin allow you to import a mysql dump file. If they give mysql shell access you can ftp up the mysql dump file, login to the mysql shell, and then run the sql file after selecting the proper database:

    source <path-to-your-file.sql>
    Code (markup):
     
    systematical, Feb 12, 2010 IP
  3. halo636

    halo636 Peon

    Messages:
    59
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    What you would need to do is save the database as a dump file (.sql) and then upload it to the Server, you then need would have to restore that .sql file on that database.

    If you do not wish to do that what you can do is ask for them to make a sql server and give you admin rights, login to it with sqlyog or navicat and then restore the .sql file from earlier from your work area.
     
    halo636, Feb 13, 2010 IP