Database issues

Ross · #1 (**permalink**) Jun 12th, 2007, 10:16

Hi everyone,

As you can tell from the following question, I know absolutely nothing about databases

I'm trying to import a database into a fresh database, but everytime I try I get this error:-

Server Replied: ERROR 1062 (23000) at line 43116: Duplicate entry '1092-133' for key 2
ERROR 1062 (23000) at line 43120: Duplicate entry '1090-142' for key 2
ERROR 1062 (23000) at line 43125: Duplicate entry '1092-9' for key 2
ERROR 1062 (23000) at line 43135: Duplicate entry '1092-4' for key 2

I tried opening it up in notepad and removing those lines, but then I got this error, when importing
Server Replied: ERROR 1044 (42000) at line 16: Access denied for user 'database1name' to database 'database2name'
ERROR 1044 (42000) at line 17: Access denied for user 'database1name' to database 'database2name'

Any ideas?

Cheers

Ross · #2 (**permalink**) Jun 12th, 2007, 11:19

Fixed it

karinne · #3 (**permalink**) Jun 12th, 2007, 12:23

And .... how did you fix it

Ross · #4 (**permalink**) Jun 13th, 2007, 09:43

I tried importing it for about the 25th time and then it worked .... As for the access denied... I had miss typed something and hadn't noticed

*scurrys away to avoid embarrassment*

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IE and FF Issues...	Aaron1988	Web Page Design	0	May 10th, 2008 15:52
Serious issues in IE7	Daimz	Web Page Design	2	Aug 21st, 2007 12:38
CSS Issues. Can you help me out?	escaflowne11	Web Page Design	7	Sep 13th, 2006 13:18
XML Code for transfering data from one SQL Server Database to another database	plolla	Other Programming Languages	1	Aug 3rd, 2006 18:37
More issues.	mreine	Webforumz Suggestions and Feedback	7	Mar 13th, 2006 01:49

		Webforumz.com > Main Forums > Program Your Website > Databases
Database issues