Database issues

This is a discussion on "Database issues" within the Databases section. This forum, and the thread "Database issues are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Jun 12th, 2007, 10:16
Reputable Member
Join Date: Oct 2006
Location: United Kingdom
Age: 20
Posts: 238
Blog Entries: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Database issues

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
Last Blog Entry: Blog Noughts and Crosses (Nov 14th, 2007)
Reply With Quote

  #2 (permalink)  
Old Jun 12th, 2007, 11:19
Reputable Member
Join Date: Oct 2006
Location: United Kingdom
Age: 20
Posts: 238
Blog Entries: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Database issues

Fixed it
Last Blog Entry: Blog Noughts and Crosses (Nov 14th, 2007)
Reply With Quote
  #3 (permalink)  
Old Jun 12th, 2007, 12:23
karinne's Avatar
SuperMember

SuperMember
Join Date: Jan 2007
Location: You know where
Age: 31
Posts: 4,617
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Database issues

And .... how did you fix it
Reply With Quote
  #4 (permalink)  
Old Jun 13th, 2007, 09:43
Reputable Member
Join Date: Oct 2006
Location: United Kingdom
Age: 20
Posts: 238
Blog Entries: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Re: Database issues

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*
Last Blog Entry: Blog Noughts and Crosses (Nov 14th, 2007)
Reply With Quote
Reply

Tags
database, importing

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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


All times are GMT. The time now is 01:31.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43