Executing SQL Script for mySQL

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • shalom_m
    Member
    • Mar 2004
    • 56

    #1

    Executing SQL Script for mySQL

    1. How can I run an SQL script to define a number of tables form c-panel?

    2. How can I connect form a program on my PC to the remote DB from through the IP?
  • justoneguy
    Junior Member
    • Jul 2005
    • 17

    #2
    Originally posted by shalom_m
    1. How can I run an SQL script to define a number of tables form c-panel?

    2. How can I connect form a program on my PC to the remote DB from through the IP?
    1. Use phpMyAdmin to upload the sql file and execute it.

    2. Depends a lot on the program, but you will definitely need to enable access to outside hosts on the database Just add % to the allowed hosts on the manage databases screen. A little more information would help be more specific (is it a program that will require an odbc driver? is it a local php script, etc.)

    Comment

    • Buddha
      Senior Member
      • Mar 2004
      • 825

      #3
      Originally posted by shalom_m
      2. How can I connect form a program on my PC to the remote DB from through the IP?
      Kylec has a FAQ on tunnelling: http://forums.dathorn.com/showthread.php?t=216
      "Whatcha mean I shouldn't be rude to my clients?! If you want polite then there will be a substantial fee increase." - Buddha

      Comment

      Working...