MayoorPatel
asked on
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
Hi there I have just tried to restart mysql server after seeing some funny messages on my sites regarding sql errors and I am now getting this when I execute
/etc/init.d/mysql restart
Error Message
Stopping MySQL database server: mysqld failed!
Starting MySQL database server: mysqld . . . . . . . . . . . . . .cat: /var/run/mysqld/mysqld.pid : No such file or directory
When I open the syslog it says this
Mar 30 22:54:55 ns211950 mysqld[15579]: 110330 22:54:55 InnoDB: Started; log sequence number 0 43685
Mar 30 22:54:55 ns211950 mysqld[15579]: 110330 22:54:55 /usr/sbin/mysqld: Error writing file '/var/run/mysqld/mysqld.pi d' (Errcode: 28)
Mar 30 22:54:55 ns211950 mysqld[15579]: 110330 22:54:55 Can't start server: can't create PID file: No space left on device
Mar 30 22:54:55 ns211950 mysqld_safe[15595]: Number of processes running now: 0
Mar 30 22:54:55 ns211950 mysqld_safe[15597]: restarted
Mar 30 22:54:55 ns211950 mysqld[15600]: 110330 22:54:55 InnoDB: Started; log sequence number 0 43685
Can anyone help?
/etc/init.d/mysql restart
Error Message
Stopping MySQL database server: mysqld failed!
Starting MySQL database server: mysqld . . . . . . . . . . . . . .cat: /var/run/mysqld/mysqld.pid
When I open the syslog it says this
Mar 30 22:54:55 ns211950 mysqld[15579]: 110330 22:54:55 InnoDB: Started; log sequence number 0 43685
Mar 30 22:54:55 ns211950 mysqld[15579]: 110330 22:54:55 /usr/sbin/mysqld: Error writing file '/var/run/mysqld/mysqld.pi
Mar 30 22:54:55 ns211950 mysqld[15579]: 110330 22:54:55 Can't start server: can't create PID file: No space left on device
Mar 30 22:54:55 ns211950 mysqld_safe[15595]: Number of processes running now: 0
Mar 30 22:54:55 ns211950 mysqld_safe[15597]: restarted
Mar 30 22:54:55 ns211950 mysqld[15600]: 110330 22:54:55 InnoDB: Started; log sequence number 0 43685
Can anyone help?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
sudo /etc/init.d/mysql restart