SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    SitePoint Member
    Join Date
    Apr 2002
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default mysql table

    The default mysql table I'm discovering keeps track of users, logins and the like. Well, quess what I'm a newbie and I dropped it (deleted it) and I'm "quessing" that my problem is stemming from this.

    Last night mysql was working fine, today it does not start up. I have also tried typing in net start mysql, this doesn't work either. Does anyone know if there is a way to get mysql running again with out having to uninstall and reinstall the whole program?

    This is the second time mysql, just out of the blue, has stopped working on me. Hopefully I have discovered the problem.

    Can anyone help me? Am I going to have to reinstall mysql?

    Thanks

  2. #2
    SitePoint Member
    Join Date
    Apr 2002
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    To late now but, sorry, quess I should have posted the above thread in the beginners forum.

  3. #3
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    no, it's fine in this forum.

    if you dropped anything related to the `mysql' database, just reinstall MySQL and it should fix it. you don't need to uninstall it first.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR

  4. #4
    SitePoint Addict
    Join Date
    Mar 2002
    Location
    Miami, Florida - Caracas, Venezuela
    Posts
    379
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by DR_LaRRY_PEpPeR
    if you dropped anything related to the `mysql' database, just reinstall MySQL and it should fix it. you don't need to uninstall it first.
    Wouldn't this overwrite databases created by Stealth0 (if any)?
    Luis

  5. #5
    SitePoint Wizard silver trophy redemption's Avatar
    Join Date
    Sep 2001
    Location
    Singapore
    Posts
    5,269
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i thought the installation doesn't overwrite any databases already existing

  6. #6
    SitePoint Addict
    Join Date
    Mar 2002
    Location
    Miami, Florida - Caracas, Venezuela
    Posts
    379
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have no idea. Hopefully not!
    Luis

  7. #7
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by lgomez
    Wouldn't this overwrite databases created by Stealth0 (if any)?
    as redemption said, no, it won't touch your stuff. it'll just install its own files. even if you uninstall MySQL, i don't think it deletes your databases.

  8. #8
    SitePoint Member
    Join Date
    Apr 2002
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wish I would have waited for your replys. I've lost all my databases
    After I originally posted, I uninstalled mysql and reinstalled it. Now, I don't know about "uninstalling", but what I did was just delete the mysql directory. I then unzipped my archived mysql zip file and clicked on the setup file and went through the setup process. Then I went to the command line and typed:

    mysqld-nt -remove and then mysqld-nt -install
    Then:
    Created a my.cnf file

    I'm quessing from your replys it was that (mysqld-nt -remove) command that wiped out my databases. I remembered doing this command earlier on in my dabblings of trying to get everything setup correctly.
    That was when I didn't even know what remotely correctly was

    What you think was it mysqd-nt -remove that wiped out my databases?

  9. #9
    SitePoint Wizard
    Join Date
    Jul 2001
    Location
    The Netherlands
    Posts
    2,617
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I don't know, but it could well be. I can tell you for the future that it is quite easy to backup your database, and then place it back later on. If you open your Explorer and go to the MySQL folder, you will see a subfolder named Data. In there are all your databases just listed as subfolders -- so if you wanted to create a new database, you could also just put a new folder in there. Just copy those folders and put them back after the re-install. That's the entire magic .

  10. #10
    SitePoint Member
    Join Date
    Apr 2002
    Posts
    19
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Cool
    Thanks Mark


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •