Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Contributions requiring us to run sql


oscommerce2006

Recommended Posts

Posted

I have noticed a number of the contributions require you to run an sql file using our favourite tool.

 

I'm new to sql and don't really understand how it works.

 

Has anyone got any good suggestions as to which tool i might use?

 

Also how do you run the sql file?

 

Many thanks,

Posted

Normally people use phpMyAdmin to manage SQL queries.

 

To run an sql file on your database you first need to access the database via phpMyAdmin.

 

Then click on the SQL tab at the top of the page.

 

Then use the Browse box to locate the .sql file on your computer.

 

Then click 'Go'

 

This uploads and runs that sql file into your database.

 

Remember - BACKUP your database first!

 

Vger

Posted

Your host may already have MyPHPAdmin available, which is a really nice interface with SQL. It looks/seems intimidating at first, but MyPHPAdmin is very easy to use, and the instruction in the contribution have been dead-on for me.

Archived

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

×
×
  • Create New...