Mysql error log path Ubuntu

Well, when you trying to restart the mysql in Ubuntu:

/etc/init.d/mysql restart

… [fail] …

First, you find the error log path of Mysql.

/var/log/mysql.*

But, the final way to fix the MySQL error:

0. su –

1. # backup database files

cp -r /var/lib/mysql /var/lib/mysql.b

2. # remove app

aptitude purge mysql-server

3. # if you have another app:mysql-server-5.0

aptitude purge mysql-server-5.0

4. # reinstall

aptitude install mysql-server

5. # recopy files

cp -r /var/lib/mysql.b /var/lib/mysql

6. # restart mysql

/etc/init.d/mysql restart

You will see, it is faster than your fixing job.

 

*: If you get error when you remove, check the article "dpkg broken" in this blog.

del.icio.us Tags: ,,,,

Regards,

Oliver

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: