Hi All,
I don't have PHPMyadmin...can someone tell me what the syntax is to execute BTS.sql
Thanks,
Tim![]()
This is a discussion on SQL syntax for execute BTS.sql? within the osCmax v1.7 Discussion forums, part of the osCmax v1.7 Forums category; Hi All, I don't have PHPMyadmin...can someone tell me what the syntax is to execute BTS.sql Thanks, Tim...
Hi All,
I don't have PHPMyadmin...can someone tell me what the syntax is to execute BTS.sql
Thanks,
Tim![]()
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
JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
Try out our osCMax at: Live Catalog Demo
Limited access Admin: Live Admin Demo
Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!
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
Yeah that will work
Cut'n paste the text file into the "SQL Query" window and click Go or Excute or Run etc... should do the trick.
JPF - osCMax Fourm Moderator - To contact, post on the forum or click here
Try out our osCMax at: Live Catalog Demo
Limited access Admin: Live Admin Demo
Feel free to add products they way you want and then purchase them -=+=- Sorry nothing will be billed or shipped!
Bookmarks