Setting up MySQL on Windows 2000
Folks, I am totally new to databases, haven't got the foggiest of what's going on here. I have downloaded and installed MySQL 3.23.29 a while back, but I still don't know how to even configure it, even though I have read several articles about using it, and consulted our webmaster, but he's got no time for a wanna-be like me... *grin*... , as well as mailing some friends about it, without success. here's my problem: In my c:\program files\mysql\data directory, there is NOTHING. There's supposed to be a folder mysql. I saw that folder there earlier. I wonder if I haven't by accident deleted it sometime. Anyways, how do I get that contents back? I used the admin tool to create the new database, called mysql, but it's empty. No tables are defined for it. How do I do that? Everyone that I asked have been doing this from Linux, and I am simply unable to follow their instructions... Once I get this fixed, I need to create a new datase, called drupal, which requires login, I need to specify host/password and other info for it. That is unfortunately the only information I've got for this problem. I hope someone makes out what my problem is! Any help would be appreciated. -- Kobus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Primary key ID gets messed up after deleting/adding
How would you actually overcome that? Wouldn't it be good if MySQL would be adapted to actually do this for you? -- Kobus "Jens Vonderheide" [EMAIL PROTECTED] 2001-04-08 19:25:48 When I first added about 10 records and then deleted a few records and then added more records it didn't replace the missing records. That's MySQL's usual behaviour. auto_increment only garantees to create unique keys. "Holes" left by deleting data are not filled. Jens - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Primary key ID gets messed up after deleting/adding
No, what is meant here is that: He has record 1 2 3 and 4. Now deletes 2 and 3. Now create 2 new records. MySQL creates them as 5 and 6, instead of 2 and 3 again... --Kobus Lindsay Adams [EMAIL PROTECTED] 2001-04-08 19:42:12 I can understand not wanting to have holes, but.. If it is a primary key, how are you going to handle updating tables that rely on that key id? If your id numbers were to shift, like you want, and you had a related sub table (one to many) and this was say, an shopping cart, then all of a sudden customer A's line items are showing up in Customer B's and not customer A's It is more common to to have reliable unique no shifting keys. You can program in some logic that deletes all related records in related tables, and then re-uses numbers if you want to 'fill' the holes, butis it really worth it? Holes are merely an aesthetic item in the vast majority of cases. Auto_increment behavior is clearly documented in the manual. On 4/8/01 9:35 AM, "David" [EMAIL PROTECTED] wrote: I have a primary key listed as ID When I first added about 10 records and then deleted a few records and then added more records it didn't replace the missing records. When I select all records to view I now get: 1 2 why didn't it go to 3, 4 and 5 after 2? 6 7 8 When I add a record it becomes record 11. Am I doing something wrong when I delete a record? I thought it would move the other records down 6 and 7 would be 3 and 4 etc... Using RedHat Linux with latest MySQL rpms: mysql-server-3.23.32-1.7 php-mysql-4.0.4pl1-3 mysql-devel-3.23.32-1.7 mysqlclient9-3.23.22-3 mysql-3.23.32-1.7 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php