At 10:32 AM 11/23/2001 +0800, ahakim wrote:
>i running php402 + mysql3.23.24beta on pc 800mhz win98.
>when pc hang was occured, then many tables in mysql
>i always use 'repair tables' command, but can't recover
>all record in that table.
>Anyone can help me to solve this problem.
"Repair tables" can only work with what it can find, it's not magic. Your
last backup is your best friend. For the future, do this:
Change operating systems to something more rugged, Windows 2000 or XP if
you want to stay in the Windows world, Linux or BSD if you want to switch
to the *nix world. These will allow you to issue mysqldump on a timed basis
so that data is regularly backed up. They are also secure, W98 isn't. They
are also more likely to stay up and not crash. Depending on your level of
comfort, I'd really recommend Linux because of the incredible depth of support.
If you are running Windows98 as web server you effectively have nothing in
the way of security or protection, and by extension any other networked
computer attached is vulnerable.
Make daily backups of your database.
If you want to use MySQL, don't run a beta, run a stable version.
Change to PostgreSQL if you want a more robust database. A bit slower than
MySQL, but much more rugged. The latest version does away with all of the
traditional complaints associated with PGSQL.
Probably not what you wanted to hear, but good luck.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]