Link to home
Create AccountLog in
Avatar of codequest
codequest

asked on

phpmyadmin import

I have two mysql db's on a hosted linux site, "db1" and "db2".  They are both Tikiwiki MySql DB's.  I have used phpmyadmin to "export" download db1.   I want to "import" db1 to overwrite db2.  I select db2 in my phymyadmin control panel, then Import > Browse to db1 > GO.   I get the message below.

What else might I do to upload and overwrite db2 with db1?
Error
SQL query: 
 
--
-- Dumping data for table `tiki_actionlog`
--
INSERT INTO `tiki_actionlog` ( `actionId` , `action` , `lastModif` , `object` , blah blah blah
 
MySQL said:  
 
#1062 - Duplicate entry '1' for key 1

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Umesh
Umesh
Flag of India image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of codequest
codequest

ASKER

Worked, but didn't seem to import all the tables properly.   Separate problem, though.  Thanks!