Erreur SQL InnoDB: Unable to lock ./ibdata1 error: 11

Dans le genre prise de tête… Solution :

sudo service mysql stop

sudo mv /var/lib/mysql/ibdata1 /var/lib/mysql/ibdata1.BKP
sudo cp -a /var/lib/mysql/ibdata1.BKP /var/lib/mysql/ibdata1

sudo service mysql start

 

 

Mots clés

• innodb
• lock
• mariadb
• mysql
• perconna