How to use PHPMyAdmin to load SQL

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.

Leave a Reply

Your email address will not be published. Required fields are marked *