开发者

Starting MySQL 5.1 with different datadir

I do regularly change the data directory from the default /var/lib/mysql to something else like /var/lib/mysql1 It works wihtout any is开发者_开发问答sues 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 moved all the files and directories from old location to new one? If no - that is what you have to do now.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜