Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Create new database table


Kjolebutikken

Recommended Posts

I have to create a new database table named information.sql regarding to a contribution I'm installing (Information unlimited v1.0).

 

Can somebody tell me how to do this and where? I have phpmyadmin, if this is the place to do it, but I'm not familiar about using it.

 

Thank you:-)

Kjolebutikken

Best regards

Kjolebutikken

Link to comment
Share on other sites

I have to create a new database table named information.sql regarding to a contribution I'm installing (Information unlimited v1.0).

 

Can somebody tell me how to do this and where? I have phpmyadmin, if this is the place to do it, but I'm not familiar about using it.

 

Thank you:-)

Kjolebutikken

 

Ok, log into php admin. Click on the data base you want to add this too, probably just one but since I"m not sure, just telling you lol. Oh, BACK UP everything first then do this.

 

When database tables pop up, click up on the top button that says "sql"

 

YOu should see a window there, now you can either cut and paste the info that is located in the information.sql file of that Information Unlimited, or you can click on "browse", go to the folder, then upload the information.sql file that way. PHP admin will tell you whether it was successful or not.

Link to comment
Share on other sites

Ok, log into php admin. Click on the data base you want to add this too, probably just one but since I"m not sure, just telling you lol. Oh, BACK UP everything first then do this.

 

When database tables pop up, click up on the top button that says "sql"

 

YOu should see a window there, now you can either cut and paste the info that is located in the information.sql file of that Information Unlimited, or you can click on "browse", go to the folder, then upload the information.sql file that way. PHP admin will tell you whether it was successful or not.

 

Ok, but if I don't know which of the existing databasetables (on the left side) to pick? Cannot see that there is one for the information box there. Do you know the name? Or should I create a brand new one? If so, how?

 

Thanks:-)

Kjolebutikken

Best regards

Kjolebutikken

Link to comment
Share on other sites

Ok, but if I don't know which of the existing databasetables (on the left side) to pick? Cannot see that there is one for the information box there. Do you know the name? Or should I create a brand new one? If so, how?

 

Thanks:-)

Kjolebutikken

 

Well if you only have the oS cart installed, there would be only one database there. Example, say you installed two databases, one for the cart, one for say a chat room. there would only be two databases listed. click on the one that is for the shopping cart. If you haven't installed any other databases, click on the one that is listed. It should somehow indicate that it's to the cart anyways. I think you're worried about inserting it into a specific place? You don't have to do that. Just click database name, then that sql button at top, and then import the file from there. It will do the rest for you. Hope I'm understanding you right.

Link to comment
Share on other sites

Well if you only have the oS cart installed, there would be only one database there. Example, say you installed two databases, one for the cart, one for say a chat room. there would only be two databases listed. click on the one that is for the shopping cart. If you haven't installed any other databases, click on the one that is listed. It should somehow indicate that it's to the cart anyways. I think you're worried about inserting it into a specific place? You don't have to do that. Just click database name, then that sql button at top, and then import the file from there. It will do the rest for you. Hope I'm understanding you right.

 

Hi Micholas,

Sorry that I did'nt understand you. I see what you mean now. On my left side in phpmyadmin I see the name of my database at top (only have one), but under there are many files (tables) listed up, f.ex. banners, category, counter etc. I thought I was supposed to create a new such file (table) in my database. The installation says:

"Create database table 'information' (file 'information.sql').

But in the contribution there also is a sql file named information.

I guess I am supposed to just run this file in the sql in phpmyadmin like you said, and nothing else? No need to create a new table? Or will a new table be created when I run the sql file? Is this what you mean?

Sorry for being "slow" :-) learning - learning.....

 

Best regards

Kjolebutikken

Best regards

Kjolebutikken

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...