Arch Linux

sodora

Member

Registered: 2007-05-05

Posts: 1

Problem on MySQL

I want to change datadir to other directory, but mysql can not run.

cp -R -p /var/lib/mysql /database/mysql

modify /etc/conf.d/mysqld

MYSQLD_ROOT="/database/mysql"

modify /etc/my.cnf

datadir = /database/mysql

[root@yanyan ~]# /etc/rc.d/mysqld start
:: Starting MySQL                                                        [FAIL]

/database/mysql/yanyan.err

080317 10:08:59  mysqld started
080317 10:08:59  InnoDB: Started; log sequence number 0 43655
080317 10:08:59 [ERROR] bdb:  /database/mysql: Permission denied
080317 10:08:59 [ERROR] bdb:  /database/mysql/log.0000000001: Permission denied
080317 10:08:59 [ERROR] bdb:  PANIC: Permission denied
080317 10:08:59 [ERROR] bdb:  PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
080317 10:08:59 [ERROR] bdb:  fatal region error detected; run recovery
080317 10:08:59 [ERROR] bdb:  /database/mysql: Permission denied
080317 10:08:59 [ERROR] /usr/sbin/mysqld: Can't create/write to file '/database/mysql/yanyan.pid' (Errcode: 13)
080317 10:08:59 [ERROR] Can't start server: can't create PID file: Permission denied
080317 10:08:59  mysqld ended

I use "-p" when I copy the folder, but it suggest that I have no permission. How to solve this problem?

luca

Member

From: Rome

Registered: 2005-10-30

Posts: 280

Re: Problem on MySQL

Hi sodora,
you must assign the right permissions on mysql dir:

chown mysql:mysql /database/mysql