Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
HELP! Accendiently deleted ALL production tables! Is there a backup anywhere? Question Question
How to backup server content? Question Question

Question

Since restoring from a backup mySQL won't start

Posted April 3, 2015 8.1k views
MySQLBackups

Hello there,

I have a Ubuntu 12.04.3 LTS (GNU/Linux 3.8.0-29-generic x86_64) droplet which I ballsed up by attempting to upgrade Ubuntu.

So I restored it to a backup from 1 week ago. However, I can’t for the life of me seem to get mySQL to start. After restoring mySQL comes up for a matter of minutes and then dies refusing to start again.

Looking in syslog, it seems to die when this comes up:

Apr 3 23:47:25 localhost kernel: [ 360.410338] type=1400 audit(1428101245.773:24): apparmor=“STATUS” operation=“profilereplace” name=“/usr/sbin/mysqld” pid=2456 comm=“apparmorparser”

Trying service mysql start come back with this:

start: Job failed to start

Does anyone have any idea what might be happening please?

Add a comment
mrjamie
By:
mrjamie

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
HELP! Accendiently deleted ALL production tables! Is there a backup anywhere? Question Question
How to backup server content? Question Question
7 comments
  • sierracircle April 4, 2015
    Reply Report

    try:

    dpkg-reconfigure mysql-server-5.5

  • mrjamie April 4, 2015
    Reply Report

    Thanks I’ll give that a go

  • mrjamie April 4, 2015
    Reply Report

    Unfortunately that did not work:

    Skipping profile in /etc/apparmor.d/disable: usr.sbin.mysqld
    start: Job failed to start
    invoke-rc.d: initscript mysql, action “start” failed.

  • kamaln7 April 4, 2015
    Reply Report

    Try running MySQL manually, does it output any errors? 

    sudo -u mysql -g mysql mysqld
  • mrjamie April 4, 2015
    Reply Report

    If I try sudo -u mysql -g mysql mysqld I get:

    150404 19:29:06 [Warning] Using unique option prefix keybuffer instead of keybuffersize is deprecated and will be removed in a future release. Please use the full name instead.
    150404 19:29:06 [Warning] option ‘thread    stack’: unsigned value 65536 adjusted to 131072

    If I try just mysql I get:

    ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ’/var/run/mysqld/mysqld.sock’ (111)

  • Show 2 more comments

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
2 answers
mrjamie June 29, 2015

To be honest I can’t remember what I did (as it was a few months ago now) but I managed to get dumps of the databases and then just fired up a new server to use only for my databases with a secure connection running between the web server and new database server. A better way to do it plus I set up regular database backups to avoid the issue happening again.

Reply Report
HappyLapisJellyfish December 16, 2020

Edit your /etc/mysql/mysql.conf.d/mysqld.cnf

Find and change the
bind-address = .......
to the IP of your droplet.

This issue happened to me once I created a new droplet from a backup. In the MySQL config file, the IP was from the old droplet.

Reply Report

Related

Looking for something else?

Ask a new question Search for more help