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...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| ||||
| ||||
| Hi All, I don't have PHPMyadmin...can someone tell me what the syntax is to execute BTS.sql Thanks, Tim |
| Sponsored Links | ||
| ||
|
#2
| ||||
| ||||
| 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 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! |
|
#3
| ||||
| ||||
| 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 |
|
#4
| |||
| |||
| Yeah that will work |
|
#5
| ||||
| ||||
| 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 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! |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Quantity Attribute syntax | torweb | osCMax v2 Features Discussion | 0 | 05-10-2006 09:30 AM |
| Can't Get Install.php To Execute | Shadeau | osCMax v1.7 Installation | 5 | 05-28-2005 01:05 PM |
| SQL syntax error | barnkin | osCommerce 2.2 Installation Help | 1 | 09-14-2004 10:13 PM |
| bts 1.2a SQL syntax error | nfmg | osCMax v1.7 Discussion | 1 | 08-21-2004 02:43 PM |
| SQL syntax error | americamba | osCommerce 2.2 Installation Help | 1 | 01-05-2004 09:34 AM |