How to load database to godaddy

Discussion in 'MySQL' started by goofblogger, Aug 14, 2008.

0
  1. #1
    I have just purchased a script called smsscript. The readme file states that I have to upload my database ( an sql extension ) to my database server. Exactly how is that done ?

    I have already sent up the mysql database on my godaddy account.

    Thanks in advance for your help.
     
    goofblogger, Aug 14, 2008 IP
  2. dcr226uk

    dcr226uk Peon

    Messages:
    174
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #2
    2 ways :)

    1. Log into your server using ssh, then execute the .sql script at the mysql database like so

    mysql -h[hostname or ipaddress of mysql server] [databasename] -u[username] -p[password] < thescript.sql

    2. Use phpmyadmin to execute a sql command (click the little sql icon) and paste the contents of the .sql file into it.

    I would suggest using option 1. an example command for option one could be (once logged into your linux server, with the .sql file in the directory you are in)

    mysql -h mysql.mydomain.com mydatabase -u myuser -p mypassword < thescript.sql

    let me know how you get on
     
    dcr226uk, Aug 14, 2008 IP