Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Execute sql query? How do I do this?


thecandlespastore

Recommended Posts

I have downloaded a contribution and it states as the first step:

 

please execute the SQL query at /sql/auction_product.sql to create new tables for the contribution the new tables call 'auctions' and 'auctions_bids'

 

I have no clue how to do this. Thank you so much for the insight!

Always grateful for any help received!!

Link to comment
Share on other sites

You must log into phpmyadmin. Most hosts have a link to it in their control panel.

 

Once in there you have to select the correct database. The page will refresh and on the top right you will see a link that says SQL, click that. The a page will come up with a box. If the sql is short just copy and paste it in to the box then click on Ok.

 

You have now added info to your database. You may want to do a backup of the database beforehand just in case. You can do that through osCommerces admin area under tools, or you can do it from phpmyadmin by clicking on Export, click select all under the table list then clicking save file as... and GO. You will get a file to download that you can reupload and overwrite your database with if something goes wrong.

Wendy James

 

Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...