Take the 2-minute tour ×
Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems.. It's 100% free, no registration required.

I'm having issues starting MySQL after it randomly stopped working a few minutes ago. I'm getting this error while trying to connect:

Connect failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

So I tried to restart MySQL (this had worked for me before) and I got this:

Stopping mysqld:                                           [  OK  ]
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]

Here's my error log:

130414 20:03:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130414 20:03:45 [Note] Plugin 'FEDERATED' is disabled.
130414 20:03:45 InnoDB: The InnoDB memory heap is disabled
130414 20:03:45 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130414 20:03:45 InnoDB: Compressed tables use zlib 1.2.5
130414 20:03:45 InnoDB: Using Linux native AIO
130414 20:03:45 InnoDB: Initializing buffer pool, size = 128.0M
130414 20:03:45 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
130414 20:03:45  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130414 20:03:46  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130414 20:03:46  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables

Can anyone offer some tips? I'm pretty noobish at this server stuff :P

share|improve this question

migrated from serverfault.com Jun 4 '13 at 13:14

This question came from our site for professional system and network administrators.

    
Wouldn't this have been better migrated to DBA.SE? –  Ladadadada Jun 4 '13 at 13:17
    
Do you have any other ibdata1 or ib_logfile0 or ib_logfile1 files on your system? You can use locate ibdata1 or sudo find / -name ibdata1 to find them. (Note that the locate database is generated daily and won't have recently created files in it.) –  Ladadadada Jun 4 '13 at 13:25
    
Also, do you have backups? I have a feeling you're going to need them. –  Ladadadada Jun 4 '13 at 13:25
    
I solved the issue by rebooting the EC2 virtual instance...weird. –  goddfree Jun 4 '13 at 17:17

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.