LinuxQuestions.org
Review your favorite Linux distribution.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 06-03-2008, 04:22 PM   #1
JJX
Member
 
Registered: Mar 2004
Location: Greece
Distribution: Debian
Posts: 351

Rep: Reputation: 31
mysql not staring


A week ago suddenly my mysql died! After this point refuses to start.
When i try to start (or restart) i get this error:

myserver:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!


I can start mysql manually bu using this command:

/usr/bin/mysqld_safe --skip-grant-tables --console
(i get no error messages to the screen)

Error logs (defined to my.cnf) doesnt have anyhthing strange (=no error messages & queries appear and function normaly if mysql start using the above command)

Reinstalling and/or upgrading disnt solve the problem
Using distro's (debian stable) my.cnf also didnt solve the problem


Any idea how to troubleshoot this?
Thanks
 
Old 06-03-2008, 05:15 PM   #2
JJX
Member
 
Registered: Mar 2004
Location: Greece
Distribution: Debian
Posts: 351

Original Poster
Rep: Reputation: 31
As always the problem is solved a little after the post.

The problem was the corrupted mysql DB.
For some reason mysql DB was corrupted (some FRM and/or MYI were missing).

You may restore from a backup (if exists). In case you dont have one, restore mysql table from an other mysql installation and change user passwords, permissions etc... (i dont know how safe is that)

It seems to work for now

Thanks
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
problem in staring apache on FC 6 raj_sai Linux - Server 1 04-14-2007 02:22 PM
My Xserver is not staring man_msc Linux - Software 1 08-28-2006 07:57 AM
Staring programs when logging into X Windows tron_thomas Linux - Software 2 06-25-2006 10:56 PM
XFree86 4.3.0 - staring in GNOME nilch Linux - Software 1 03-16-2003 10:37 AM
Suse 7.1, apache not staring genericuser Linux - Newbie 2 06-10-2001 01:08 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 12:32 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration