Not to add insult to injury, but keeping backups on the same machine and media your databases are installed on is asking for trouble. And power outages are predictable, so UPS protection is critical. Enough said.
I would speculate that one or more of the files in the /data/mysql/ folder were open for a write operation when the power went out, corrupting the file(s). Since the mysql database controls rights/privs for the other databases, problems with it could transcend to problems accessing the other DB's. We have a process in place to prevent data loss: - All database schema are installed via scripts, which are stored on CD-RW media. - All privileges on our MySQL servers are scripted. Once installed, these scripts are kept on the CD-RW with the database schema scripts. - Every morning at 2am, a cronjob creates a backup of each database (including mysql) - When the backups are safely created, the cronjob does an SSH connection to another server and ftp's the backups to the other machine. - The backups are moved to CD-RW This is not a bullet-prof plan, but it gets the job done for us. Gerald Jensen ----- Original Message ----- From: "kibserv-FtS Setiqueue" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Saturday, May 18, 2002 3: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
