About Club osCommerce

Showcasing osCommerce - the good, the bad and the ugly!

StumbleUpon It! DIGG It!

How to use PHPMyAdmin to load SQL

Written By Gary on Mar 12 2008 ·

Sometimes it is necessary to action a SQL file when installing contributions into osCommerce. This is really simple, and consists of you making changes to your shop database.

You will need to have access to a piece of software called "PHP My Admin" - thankfully this is supplied as standard on 99.9% of all hosting accounts. So you should log into your control panel and find it! You can see some general screenshots by clicking here.

All you need to do is click the name of your osCommerce database in the small left hand pane. This will bring up the right hand pane which has tabs along the top. One of these tabs is called "SQL". Click that, and then paste the contents of the SQL into the box and press go. DONE!

Here's a video that shows how to do this:

However, you should note that PHP My Admin is a VERY powerful tool and it would be quite easy to nuke your whole database if you did something wrong. For this reason, I suggest that you BACKUP your shop database before making any change to it.


Buy Gary A Beer?
Buying me a "beer" helps me to keep my contributions updated and keep this blog alive. Cheers!


No Comments

No comments yet.

Leave a comment

RSS feed for comments on this post · TrackBack URL

Hot 100 osCommerce Shops

View the osCommerce HOT 100These are the best looking, most exceptional osCommerce Stores as voted for by you.

New to osCommerce - get inspiration from these beautiful shops. Reckon your site has what it takes to become a member of the HOT 100? Submit it!