Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

How do you run an sql file on server? Please Help!


deathgod

Recommended Posts

I have come across several contribution that require me to update my database by running an sql file and its stumped me. Please Help! :'(

Installation Instructions are:

1) Run the Required SQL statement using the file allprods.sql

2) Etc...

I've looked through the contribution thread and they are all vague so please don't redirect me to contributions support forum.

Nick

Menou and unome

Link to comment
Share on other sites

I have come across several contribution that require me to update my database by running an sql file and its stumped me. Please Help! :'(

Installation Instructions are:

1) Run the Required SQL statement using the file allprods.sql

2) Etc...

I've looked through the contribution thread and they are all vague so please don't redirect me to contributions support forum.

Nick

 

 

Go to your hosting control panel and click on the database link. You should then see a link to phpmyadmin. Click on it then choose your database and then click on the sql tab at the top. You can then click on the browse button and drill down to the sql file you need to run and then click on go. If it is not a file but a list of commands then copy and paste them in to the window instead.

The Knowledge Base is a wonderful thing.

Do you have a problem? Have you checked out Common Problems?

There are many very useful osC Contributions

Are you having trouble with a installed contribution? Have you checked out the support thread found Here

BACKUP BACKUP BACKUP!!! You did backup, right??

Link to comment
Share on other sites

other contributions that i need to install and require me to run sql files are

1/purchase without account

2/all products with images 4.4

3/affiliate2.5

4/dynamenu

5/wishlist

and i'm sure there will be more in future

Menou and unome

Link to comment
Share on other sites

other contributions that i need to install and require me to run sql files are

1/purchase without account

2/all products with images 4.4

3/affiliate2.5

4/dynamenu

5/wishlist

*and i'm sure there will be more in future:)

Menou and unome

Link to comment
Share on other sites

Thank you Richard, ignore my above 2 posts i think we posted at the same time. I did what you said and it worked. thank you. BTW i had to copy the data from notepad into the query window, the import file didn't work. this was for the wishlist 3.5d contribution.

Thanks again

Nick

Talking Is Not Communication - Kubo Tite

Yes, i am a bleach fan

Menou and unome

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...