Post by Dubblicious » Wed Jul 13, 2011 3:19 am

I want to have Opencart on local host mirror my online store so I downloaded all the files from my server to localhost and set up Opencart, I then realized that I needed to get a dump of my database then install it via http://localhost/phpmyadmin. I found my opencartdb in localhost/phpmyadmin and imported the database from my server to over-write the local one but then got this error.
Error

SQL query:

--
-- Dumping data for table `country`
--
INSERT INTO `country` ( `country_id` , `name` , `iso_code_2` , `iso_code_3` , `address_format` , `postcode_required` , `status` )
VALUES ( 1, 'Afghanistan', 'AF', 'AFG', '', 0, 1 ) ;

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 'PRIMARY'

I am hoping someone has a easy solution to this problem. I do not need to over-write table for contry since I have not changed that on my server or locally.
Thanks in advance for your advice.

User avatar
New member

Posts

Joined
Tue Jun 14, 2011 2:35 pm

Post by Dubblicious » Wed Jul 13, 2011 3:27 am

I just downloaded the database without the table for country but now I get a different error when I try to import the database

Error

SQL query:

--
-- Dump dei dati per la tabella `banner`
--
INSERT INTO `banner` ( `banner_id` , `name` , `status` )
VALUES ( 8, 'Showcase Banner', 1 ) ;

MySQL said: Documentation
#1062 - Duplicate entry '8' for key 'PRIMARY'

User avatar
New member

Posts

Joined
Tue Jun 14, 2011 2:35 pm

Post by Dubblicious » Wed Jul 13, 2011 3:35 am

It seems that every time I remove a table from the dump download I get a new error from different table. frustrating. ???

User avatar
New member

Posts

Joined
Tue Jun 14, 2011 2:35 pm
Who is online

Users browsing this forum: No registered users and 32 guests