SQL Installation Question

[starmakersandy]

I have a quick question about SQL installation.

 

I'm trying to install the SPPC 4.1.1 contribution and I ran into this instruction:

 

"Run the spcc_v41_install.sql database installation file on your MySQL database."

 

I know next to nothing about SQL (just learning), I'm using MyPHPAdmin online through my webhost control panel... does an install mean an import?

 

Will I be importing tables or structure?

 

I just spent a few hours completely reinstalling and reconfiguring my catalog (it was corrupted when my webhost migrated the server) and I don't want to botch up my database. I have backed it up to my hard drive, of course, but unfortunately, I haven't yet been able to figure out how to import it back to the server. I have a previous version of the db that I'm trying to get customer and order information out of, but so far no luck... but that's another sorry tale...

 

Thanks!

 

Sandra

[GemRock]

Yes it means to import. You can either click SQL or Import after loging in phpMyAdmin. Both mean the same thing depending on the function of the scripts. For a few handreds or so of lines of sql scripts you could simply copy & paste into the SQL window; for a whole database sql backup file, you could choose import and then locate the file on your local pc. Some servers have a file size limit. So if yours is too big (thousands of products) you may have to break it into two. If only need some parts of the data, then you need to open the sql file in a good text editer, and find that part of data you want. Then copy & paste into the sql window and click Go. To do this, you will need to understand sql script.

 

Ken