Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Running SQL


DennisJones

Recommended Posts

I am trying to install a contribution (my first) and have come across the following. Can someone please give me a clue as to how I run the SQL statements? This seems to assume that you know what you are doing. Thanks

 

 

"Run the following SQL statement in whatever program you use to access your OSC database (?phpMyAdmin?) or if you have an option to run a *.sql file, I have included one that will accomplish the same thing so you can just run the included extra_images.sql file, either way should work fine. ......................"

 

(I am using Oscommerce 2.2 RC2)

Link to comment
Share on other sites

Dennis,

 

Typically you would run a program like myphpadmin that was provided by your host. Most hosting companies require that you enter the database section ( same section where you created your OSC database) and run or manage the database. Once you are in myphpadmin you will see a SQL tab, open that.......copy and paste the SQL statement provided in the contribution.

 

BUT, first and foremost.......BACK UP BEFORE YOU BEGIN THIS PROCESS !

 

 

Chris

Link to comment
Share on other sites

Dennis,

 

Typically you would run a program like myphpadmin that was provided by your host. Most hosting companies require that you enter the database section ( same section where you created your OSC database) and run or manage the database. Once you are in myphpadmin you will see a SQL tab, open that.......copy and paste the SQL statement provided in the contribution.

 

BUT, first and foremost.......BACK UP BEFORE YOU BEGIN THIS PROCESS !

 

 

Chris

 

 

Thanks Chris, yes I found it ..... thanks for your help Dennis

Link to comment
Share on other sites

Thanks Chris, yes I found it ..... thanks for your help Dennis

 

I hope you don't mind another question but I have been developing a store on a test internet domain and at some point will want to migrate it to another domain with another hosting provider. Moving most of the site is easy but how do I migrate the SQL database onto the new service? Do I use the import and export tools in phpMyAdmin?

 

Thanks Dennis

Link to comment
Share on other sites

Dennis,

 

you can export it, then import it to the new domain.

 

fairly simple.

 

Just post it for more advice when you finally decide to move it, I am sure you will get the answers you need.

 

 

Chris

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...