This ( http://www.mysql.com/doc/T/a/Table_maintenance.html ) is a good place to start with corrupted MySql databases. If you backup again and run myisamchk on your tables, you could recover the information. There are a couple of other methods. Your Mysql setup information in stored in a file called my.cnf inside your etc directory. Make sure your data directories are pointing to the base dir. e.g. Here is my setup [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib Restart mysql and httpd if you made those changes (with /etc/init.d/mysqld restart and /etc/init.d/httpd restart from a prompt, logged in as root) Now, once you have that setup correctly, PhpMyAdmin might come to your rescue. On a default install of MySql (both from binaries and compiled) a new database called mysql is created which lists all the users for the mysql server, etc. Make sure you re-create the users and passwords as they existed in your previous […]
[Continue Reading...]
