myisamchk -q Does a Quick check of the files...
See the manual for the options to do a full repair / recovery of the files. ----- ??) Perhaps the backup files were already corrupt before the crash??? ??) Perhaps you have some issues with your hard disk? You can buy a CDRW drive for about $120 US.... well worth the investment. Good Luck, -- Erik ----- Original Message ----- From: "kibserv-FtS Setiqueue" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Saturday, May 18, 2002 1:44 PM Subject: Database and all backups lost at same time > This is an odd one. I seem to have lost all databases and backups > simultaneously. > > I keep daily backups for upto 7 days. This morning after a power outage I > noted I was unable to login. Every user and password I tried was denied. I > checked the files in the mysql data folder and they were all there and > seemed fine. They matched exactly to those in the past 7 days of backups. > I even tried to restore from each of the 7 days of backups with no result. > > I removed all the files in the data/mysql/ folder and restarted mysql again. > I was able to login as root with no password but found every other database > I tried to use came back with 'ERROR 1049: Unknown database'. I also > checked these files and they are all there. I am now able to 'use mysql' > since it is empty. > > Any ideas on what may have happened. Since it seems to affect all databases > and all backups I have to believe there is some corruption within the mysql > server itself and not the data files. > > -Jason > > > > > --------------------------------------------------------------------- > 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
