nofel — 2013-11-07T07:42:50-05:00 — #1
I am trying to import database into myphpadmin, but the operation is aborted in middle with this error i tried my localhost as well as other server but same error. how can i fix it?
rubble — 2013-11-07T07:47:10-05:00 — #2
Posting the sql code here would be a start.
nofel — 2013-11-07T16:33:34-05:00 — #3
for personal reason, i am not posting the code here. but its in pastebin.
rubble — 2013-11-07T16:38:49-05:00 — #4
for personal reason, i am not posting the code here.
I can understand that nofel.
Are you trying to input all that in one go? If so I would try breaking it down into smaller chunks to start with.
nofel — 2013-11-07T16:42:04-05:00 — #5
yes all in one go, if breaking down help, yes sure. but how?
rubble — 2013-11-07T16:58:29-05:00 — #6
You can do each individual create and insert on their own but that would take some time.
I would delete all the inserts from the sql code and just run the create tables first and then do all the smaller inserts together and finally the big inserts on their own.
This should work and if not it will narrow down where the problem is. There are also other options in phpmyadmin to ignore errors etc. but it is a while since I have used it.
nofel — 2013-11-08T04:09:18-05:00 — #7
while i paste queries (really long to copy and paste) into sql tab, in last 3rd i got this back
1062 - Duplicate entry '12' for key 'PRIMARY', how do i debug, the query is very long
rubble — 2013-11-08T05:44:45-05:00 — #8
In notepad++ or what ever you use it should display the code so that it is easier to read.
As I say I have not done this for a while and I presume you have a primary key on one of the columns/rows and it is either the 12th one that is the problem or you have two keys with 12 as the content. So search for 12?
nofel — 2013-11-08T05:52:57-05:00 — #9
yes i have open in textedit, but so many 12, its crazy to search something like that,plus i am getting a lot of error which says "Duplicate entry '1' for key 'PRIMARY'", isn't there easy way to extract all create table command from a mix table, where its creating and inserting?