Starting MySQL 5.1 with different datadir

Question

I do regularly change the data directory from the default /var/lib/mysql to something else like /var/lib/mysql1 It works wihtout any issues on 5.0

On 5.1 version of Mysql, it fails to start once I change the datadir with the following message...

Starting MySQL.Manager of pid-file quit without updating file.[FAILED]

I have already created the new directory and changed it's permission. Anything else must be going wrong and I can not figure it out.

Update:

There are 2 error messages in the error log.

[ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

have you ran mysql_upgrade? MySql 5.1 has some new tables in the INFORMATION_SCHEMA database that seem to be missing — The Scrum Meister
– The Scrum Meister, Commented Jan 10, 2011 at 8:43
@The Scrum Meister: his mysql instance cannot find mysql database, which stores all the service data. INFORMATION_SCHEMA is a virtual database contains of set of views, it never persists in any kind. — zerkms
– zerkms, Commented Jan 10, 2011 at 8:58
I reinstalled mysql 5.1 version using rpm -e and rpm -ivh and it solved the problem. — shantanuo
– shantanuo, Commented Jan 10, 2011 at 9:17

zerkms · Accepted Answer · 2011-01-10 08:57:24Z

1

Have you moved all the files and directories from old location to new one? If no - that is what you have to do now.

answered Jan 10, 2011 at 8:57

256k73 gold badges447 silver badges551 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1