Re: mysql connect problem

Addressed to: "ScourNepal.com" <sales@scournepal.com> php-db@lists.php.net ** Reply to note from "ScourNepal.com" <sales@scournepal.com> Sun, 25 Jun 2000 23:32:38 -0700 > > Lights went off while MySQL was still running, I think that is why > when I turned the computer back on, it refuses to connect... > > If I run php-mysql files, the computer gets jerky now.. and if I try > some commands at MySQL, it can't connect... > > what should I do?! Read section 13.4 of the MySQL manual, and see if you can revover your data. ----------------------------------------------- 13.4 Using isamchk for crash recovery The file format that MySQL uses to store data has been extensively tested, but there are always external circumstances that may cause database tables to become corrupted: The mysqld process being killed in the middle of a write Unexpected shutdown of the computer (for example, if the computer is turned off) A hardware error This chapter describes how to check for and deal with data corruption in MySQL databases. If your tables get corrupted a lot you should try to find the reason for this! See section G.1 Debugging a MySQL server. ----------------------------------------------- You may have to run it on all the tables open when the crash happened. I'm paraniod, so if you have the disk space available, I would make a backup copy the entire directory containing all your databases before you do ANYTHING else with them. It might be best to just hit all the tables in all the databases, and not worry about how to determine what was open when it failes. Rick Widmer Internet Marketing Specialists www.developersdesk.com