Top » Catalog » How To » RSQL


How To Run SQL

How To Run SQL

By now you might be trying to install contributions and are stuck on how to "run" the SQL

1) Go to your Host's control panel for your site.

2) Click on the icon for Database administration or Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites.

If you can’t find this, please consult your Host's help desk. You might have to click on Manage Database or some link like that.
3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box.
4) Click on "SQL" on the navigation bar.
5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on the Import tab and follow the on screen prompts.
6) For both methods click "Go".
7) If all goes well, your SQL query will run successfully.

For another explanation on running sql.

Or for a contribution to allow you to run SQL Scripts from Admin.

Whilst we are on the subject of MySQL, this link will solve most MySQL5/Left Join/1054 errors when your host upgrades to mysql5 without telling you.

Reviews (1)
0 items
Share Product
Share via E-Mail Share on Facebook Share on Twitter Share on Google Buzz Share on Digg
Manufacturer Info
Other products
Quick Find
Use keywords to find the product you are looking for.
Advanced Search