Adding Countries and Zones

[Guest]

When I started my shop, I just wanted to ship to the US. Now, however we'd like to add back in all the countries and zones. Is there an easy way to do this? So far I've just been "hand entering everything" but it's taking so long and I need to do this for 3 other shops.

 

Thanks so much!

[Guest]

I just tried exporting the database from another untouched version of oscommerce. I exported it from tthat site and then tried to upload it on the site I want fixed. I got this:

SQL-query:

 

-- phpMyAdmin SQL Dump

-- version 2.6.1-rc1

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Sep 18, 2005 at 08:22 AM

-- Server version: 4.0.21

-- PHP Version: 4.3.10

--

-- Database: `wish2_osc1`

--

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

--

-- Table structure for table `countries`

--

CREATE TABLE `countries` (

 

`countries_id` int( 11 ) NOT NULL AUTO_INCREMENT ,

`countries_name` varchar( 64 ) NOT NULL default '',

`countries_iso_code_2` char( 2 ) NOT NULL default '',

`countries_iso_code_3` char( 3 ) NOT NULL default '',

`address_format_id` int( 11 ) NOT NULL default '0',

PRIMARY KEY ( `countries_id` ) ,

KEY `IDX_COUNTRIES_NAME` ( `countries_name` )

) TYPE = MYISAM AUTO_INCREMENT =240

MySQL said:

 

#1050 - Table 'countries' already exists

 

 

Any ideas?

[♥Vger]

INSERT INTO countries

 

followed by the list you wish to insert

 

Vger