SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Zealot codewrecker's Avatar
    Join Date
    Feb 2002
    Location
    U.S.A.
    Posts
    105
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL possible problems

    I hear from time to time people report that they have problems and have to "re-build" their data bases. I am new to MySQL and php but plan to build a fairly elaborate site build on these two technologies. I'm just afraid once built I could experience major unforseen problems??

    Just for my information what are some of the major things that could go wrong with a databases (MySQL specifically) I guess what I'm trying to do is anticipate possible problems then maybe read up on it ahead of time just in case.

    I hope this questions doesn't sound too stupid or general.
    CodeWrecker

  2. #2
    SitePoint Wizard samsm's Avatar
    Join Date
    Nov 2001
    Location
    Atlanta, GA, USA
    Posts
    5,011
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I was curious about this topic and found this link:

    4.4 Disaster Prevention and Recovery
    http://www.mysql.com/documentation/m...ter_Prevention
    Using your unpaid time to add free content to SitePoint Pty Ltd's portfolio?

  3. #3
    SitePoint Zealot codewrecker's Avatar
    Join Date
    Feb 2002
    Location
    U.S.A.
    Posts
    105
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    thanks!

    I should have thought to look there. Thanks for the link...good info!
    CodeWrecker

  4. #4
    SitePoint Wizard samsm's Avatar
    Join Date
    Nov 2001
    Location
    Atlanta, GA, USA
    Posts
    5,011
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Some printed info I have on the topic suggests using the utility myisamchk on various data files in the event of trouble. Thing is you shouldn't have mysql running while you use it.

    Anyway, it's in the same chapter of mySQL documentation...
    4.8.4 Using mysqlcheck for Table Maintenance and Crash Recovery
    http://www.mysql.com/doc/U/s/Using_mysqlcheck.html

    <edit> I got twisted up with that link... there really isn't much info about myisamchk there but there is info about mysqlcheck which actually souds more helpful.
    Last edited by samsm; Jun 22, 2002 at 07:39.
    Using your unpaid time to add free content to SitePoint Pty Ltd's portfolio?


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
  •