Sziasztok!

Mysql adarbázis könytárát szeretném áthelyezni Ubuntu 9.10.

google-ban lévő leírások szerint:

- átmásolom a /var/lib/mysql könyvtárat az /xx/mysql
- my.cnf: datadir=új hely

-/etc/apparmor.d/usr.sbin.mysqld fájlban a /var/lib/mysql  bejegyzéseket 
átírom /xx/mysql   -re.

/etc/init.d/apparmor restart
/etc/init.d/mysql restart   [fail]


/var/log/syslog:

Jan  6 09:21:54 troodon /etc/init.d/mysql[2698]: 0 processes alive and 
'/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan  6 09:21:54 troodon /etc/init.d/mysql[2698]: 
#007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan  6 09:21:54 troodon /etc/init.d/mysql[2698]: error: 'Can't connect 
to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan  6 09:21:54 troodon /etc/init.d/mysql[2698]: Check that mysqld is 
running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan  6 09:21:54 troodon /etc/init.d/mysql[2698]:
Jan  6 09:22:15 troodon mysqld_safe[2772]: started
Jan  6 09:22:15 troodon kernel: [ 4985.512631] type=1503 
audit(1262766135.496:52): operation="mknod" pid=2774 parent=2735 
profile="/usr/sbin/mysqld" requeste
d_mask="w::" denied_mask="w::" fsuid=0 ouid=0 
name="/xx/mysql/troodon.lower-test"
Jan  6 09:22:15 troodon mysqld[2775]: 100106  9:22:15 [Warning] Can't 
create test file /xx/mysql/troodon.lower-test
Jan  6 09:22:15 troodon kernel: [ 4985.512689] type=1503 
audit(1262766135.496:53): operation="mknod" pid=2774 parent=2735 
profile="/usr/sbin/mysqld" requeste
d_mask="w::" denied_mask="w::" fsuid=0 ouid=0 
name="/xx/mysql/troodon.lower-test"
Jan  6 09:22:15 troodon mysqld[2775]: 100106  9:22:15 [Warning] Can't 
create test file /xx/mysql/troodon.lower-test
Jan  6 09:22:15 troodon mysqld[2775]: 100106  9:22:15  InnoDB: Operating 
system error number 13 in a file operation.
Jan  6 09:22:15 troodon mysqld[2775]: InnoDB: The error means mysqld 
does not have the access rights to
Jan  6 09:22:15 troodon mysqld[2775]: InnoDB: the directory.
Jan  6 09:22:15 troodon mysqld[2775]: InnoDB: File name ./ibdata1
Jan  6 09:22:15 troodon mysqld[2775]: InnoDB: File operation call: 'open'.
Jan  6 09:22:15 troodon mysqld[2775]: InnoDB: Cannot continue operation.
Jan  6 09:22:15 troodon kernel: [ 4985.537374] type=1503 
audit(1262766135.520:54): operation="open" pid=2774 parent=2735 
profile="/usr/sbin/mysqld" requested
_mask="rw::" denied_mask="rw::" fsuid=108 ouid=108 name="/xx/mysql/ibdata1"
Jan  6 09:22:15 troodon mysqld_safe[2782]: ended


Van valakinek ötlete?


_________________________________________________
linux lista      -      [email protected]
http://mlf2.linux.rulez.org/mailman/listinfo/linux

válasz