SQL syntax for execute BTS.sql?

[nfmg]

Hi All,

I don't have PHPMyadmin...can someone tell me what the syntax is to execute BTS.sql

Thanks,

Tim

[jpf]

You need a MySQL Admin tool - like phpMyAdmin (cross platform & php based). There is many others including the command line version that is included with MySQL and even a Windows based "MySQL Front" and others....

Short answer - Install phpMyAdmin on your server and setup the config/database access and use that.

Longer and harder answers:

You could even use many higher end database programs (if configured properly) - like MS-Access via OBDC connection.

phpMyAdmin is free and easy to install on any webserver - it does not have to be installed on the SAME server as where the database is stored. I use it on a LOCALHOST that access a database 1300+/- miles away (according to mapquest). You may have to ask for global IP access for your MySQL user name or if you have a fixed IP address then give them that to add to your access.

If your really into SQL then use standard SQLcommands to open the database and append data from this file. I am not into SQL so don't ask me exacly on how to do it this way.

Good Luck

[nfmg]

I have a rudimentary SQL admin tool available. I gather from further reading that I just need to paste the contents of the BTS.sql file into the SQL query window that I have on Dotster's hosting.

That sound about right?

Tim

[Anonymous]

Yeah that will work

[jpf]

Cut'n paste the text file into the "SQL Query" window and click Go or Excute or Run etc... should do the trick.