UK zones and codes

[DABarton]

Where do I put the file UK_zones.sql?

[♥geoffreywalton]

Sql

 

1) Go to your ISPs admin area for your site.

 

2) Click on the icon for Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk.

 

3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box.

 

4) Click on "SQL" on the navigation bar.

 

5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on Import and follow the on screen prompts.

 

6) For both methods click "Go"..

 

7) If all goes well, your SQL query will run successfully

 

For another explanation see:-

 

http://www.oscommerce.com/forums/index.php?sho...dmin+mysql+code

 

Or for a contribution to allow you to run SQL Script from Admin

 

http://www.oscommerce.com/community/contributions,4567

 

Cheers!

[10_little_orcs]

Edit: alright, Geoffrey was 3 minutes faster than I was.:) He's of course perfectly right.

 

-------------------------------

You don't exactly need to put the file anywhere, but have to import it into your database.

I recommend making a backup from your database first (always a good idea before changing anything)!

Choose your favorite db manager (e.g. phpmyadmin), export your database by using the "export" button somewhere in the top of the page.

Save your export.

Then, click on the import button and choose the sql.file.

Execute the import - done.

Hope that helps,

 

10 little orcs

 

 

Where do I put the file UK_zones.sql?

[♥geoffreywalton]

Cut and paste is the secret, must have posted it 20 odd times (Could only find it once in google), but hey what else have I got to do on a Sunday.

 

Just finished another product file conversion for import by EP and the cinema calls.......

[DABarton]

Sql

 

1) Go to your ISPs admin area for your site.

 

2) Click on the icon for Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk.

 

3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box.

 

4) Click on "SQL" on the navigation bar.

 

5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on Import and follow the on screen prompts.

 

6) For both methods click "Go"..

 

7) If all goes well, your SQL query will run successfully

 

For another explanation see:-

 

http://www.oscommerce.com/forums/index.php?sho...dmin+mysql+code

 

Or for a contribution to allow you to run SQL Script from Admin

 

http://www.oscommerce.com/community/contributions,4567

 

Cheers!

 

I'm using siteground to host the shop but godaddy hosts the domain name. I found a phpgadmin button in sitegrounds cpanel. I clicked that, then clicked the PostgreSQL link in the navigation bar on the left hand side. I get the tabs; Databases, account and export. On the databases tab it says no databases found. I get a link to create a database.

[♥geoffreywalton]

I'm using siteground to host the shop but godaddy hosts the domain name. I found a phpgadmin button in sitegrounds cpanel. I clicked that, then clicked the PostgreSQL link in the navigation bar on the left hand side. I get the tabs; Databases, account and export. On the databases tab it says no databases found. I get a link to create a database.

 

Never used postgress so please ignore if I am talking rubbish.

 

Doesn't osc only work on mysql?

 

But if you can set lbs to kg as per you other post, I would suspect there is a link somewhere to mysql.

 

Any other godaddy users out there?

[DABarton]

Never used postgress so please ignore if I am talking rubbish.

 

Doesn't osc only work on mysql?

 

But if you can set lbs to kg as per you other post, I would suspect there is a link somewhere to mysql.

 

Any other godaddy users out there?

 

My only other option is to open the sql file in notepad and manually enter in each country and its corrosponding code... Which will take a while.

[Guest]

I'm using siteground to host the shop but godaddy hosts the domain name. I found a phpgadmin button in sitegrounds cpanel. I clicked that, then clicked the PostgreSQL link in the navigation bar on the left hand side. I get the tabs; Databases, account and export. On the databases tab it says no databases found. I get a link to create a database.

phpmyadmin will do the job for you.