Sorry, yes I did run myisamchk *.MYI -r in all the Database folders and everything repaired fine
After trying to restart the Mysql Server, there is a mysql.sock file in the mysql folder (appears to be left over from the crash). >From the /var/lib/mysql/mysql folder... [root@SQLServer1 mysql]# ll total 108 -rw-rw---- 1 mysql mysql 8778 Oct 22 17:50 columns_priv.frm -rw-rw---- 1 mysql mysql 0 Oct 22 17:50 columns_priv.MYD -rw-rw---- 1 mysql mysql 1024 Oct 22 17:50 columns_priv.MYI -rw-rw---- 1 mysql mysql 8982 Oct 22 17:50 db.frm -rw-rw---- 1 mysql mysql 604 Oct 22 17:50 db.MYD -rw-rw---- 1 mysql mysql 3072 Oct 22 17:50 db.MYI -rw-rw---- 1 mysql mysql 8641 Oct 22 17:50 func.frm -rw-rw---- 1 mysql mysql 0 Oct 22 17:50 func.MYD -rw-rw---- 1 mysql mysql 1024 Oct 22 17:50 func.MYI -rw-rw---- 1 mysql mysql 8958 Oct 22 17:50 host.frm -rw-rw---- 1 mysql mysql 0 Oct 22 17:50 host.MYD -rw-rw---- 1 mysql mysql 1024 Oct 22 17:50 host.MYI -rw-rw---- 1 mysql mysql 8877 Oct 22 17:50 tables_priv.frm -rw-rw---- 1 mysql mysql 285 Oct 22 17:50 tables_priv.MYD -rw-rw---- 1 mysql mysql 3072 Oct 22 17:50 tables_priv.MYI -rw-rw---- 1 mysql mysql 9148 Oct 22 17:50 user.frm -rw-rw---- 1 mysql mysql 1391 Oct 22 17:50 user.MYD -rw-rw---- 1 mysql mysql 2048 Oct 22 17:50 user.MYI All the Databases are there, infact, that was the quickest way for me to get the backup server running, I copied all the files to the backup folder (excluding the files from the mysql subfolder). Thanks Roger SQL, MySQL -----Original Message----- From: Ed Carp [mailto:erc@;pobox.com] Sent: Tuesday, October 22, 2002 7:27 PM To: Roger Davis; [EMAIL PROTECTED] Subject: RE: Can't Restart Server > 021022 17:54:13 mysqld started > 021022 17:54:13 bdb: PANIC: No such file or directory > 021022 17:54:13 Can't init databases > 021022 17:54:13 mysqld ended Have you tried all the obvious things before you posted? > [mysqld] > datadir=/var/lib/mysql Is this directory exist - if so, what's in it? If there are databases there, have you run the repair utility? sql, query --------------------------------------------------------------------- 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
