Mysql veut pas déménager

[Daniel Caillibaud]

Bonjour,

Un truc bizarre avec hardy, impossible de mettre mysql (5.0.51a-3ubuntu5) ailleurs que dans /var/lib/ ?

Chez moi, en root :

/etc/init.d/mysql stop
mv /var/lib/mysql /home/
sed -i -e '/datadir/ s#/var/lib/#/home/#' /etc/mysql/my.cnf
/etc/init.d/mysql start

Déclenche

May 11 19:23:45 h2 mysqld_safe[17850]: started
May 11 19:23:45 h2 mysqld[17854]: 080511 19:23:45 [Warning] Can't create test file /usr/local/mysql/h2.lower-test
May 11 19:23:45 h2 mysqld[17854]: 080511 19:23:45 [Warning] Can't create test file /usr/local/mysql/h2.lower-test
May 11 19:23:45 h2 mysqld[17854]: 080511 19:23:45  InnoDB: Operating system error number 13 in a file operation.
May 11 19:23:45 h2 mysqld[17854]: InnoDB: The error means mysqld does not have the access rights to
May 11 19:23:45 h2 mysqld[17854]: InnoDB: the directory.
May 11 19:23:45 h2 mysqld[17854]: InnoDB: File name ./ibdata1
May 11 19:23:45 h2 mysqld[17854]: InnoDB: File operation call: 'open'.
May 11 19:23:45 h2 mysqld[17854]: InnoDB: Cannot continue operation.
May 11 19:23:45 h2 mysqld_safe[17861]: ended

C'est pareil chez vous ?
(j'ai vérifié tous les droits, je comprend pas..., sous gutsy, ces qq lignes de code marchent très bien).

Pour remettre comme avant, c'est

mv /home/mysql /var/lib/
sed -i -e '/datadir/ s#/home/#/var/lib/#' /etc/mysql/my.cnf
/etc/init.d/mysql start

-- 
Daniel

Aujourd'hui les gens connaissent le
prix de tout et la valeur de rien.
Oscar Wilde