LinuxQuestions.org
Visit the LQ Articles and Editorials section
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 03-13-2013, 08:44 AM   #16
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 14,589

Rep: Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558

Quote:
Originally Posted by suresh.k View Post
I don't have much experience on mysql, so i din'd understand very much from your links
Can u please briefly explain how to resolve.
We did, but you don't understand the answer. And as you've been asked several times in the past, you need to spell out your words.

Since you want to be spoon-fed:
  • You posted the question, then went on vacation. This obviously can't be that important.
  • Your logs are plainly telling you, that you have corrupted data, possibly from an incorrect DB shutdown.
  • The logs also provided you links to the MySQL site (which kirukan even pointed you to). Those links have several possible solutions.
  • You've been told to start mysql with force recovery enabled.
  • You've not done or tried any of the possible solutions, and don't even want to be bothered to read/understand what was posted.
We can't make things more plain. If you want someone to come type commands in for you, then you need to find a consultant and pay them. Otherwise, since you are the administrator, this will involve you showing some effort on your part. You seem to have left a production database down for about two weeks.
 
2 members found this post helpful.
Old 03-19-2013, 02:13 AM   #17
suresh.k
Member
 
Registered: Aug 2011
Location: Hyderabad, AP, India
Distribution: centos, Ubuntu
Posts: 163
Blog Entries: 1

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by Habitual View Post
Post #6 gives detailed and exact instructions how to fix this issue.
I have already followed that procedure but i cant get it,
I posted the error which iam getting after executing below command
#mysqld_safe --skip-grant-tables &
Quote:
kirukan is merely asking if you've searched through the mysql bug system.

All 3 links should be bookmarked and read slowly.
Ok i will read those links thoroughly and then i get back u
 
Old 03-19-2013, 02:16 AM   #18
suresh.k
Member
 
Registered: Aug 2011
Location: Hyderabad, AP, India
Distribution: centos, Ubuntu
Posts: 163
Blog Entries: 1

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by TB0ne View Post
We did, but you don't understand the answer. And as you've been asked several times in the past, you need to spell out your words.

Since you want to be spoon-fed:
  • You posted the question, then went on vacation. This obviously can't be that important.
  • Your logs are plainly telling you, that you have corrupted data, possibly from an incorrect DB shutdown.
  • The logs also provided you links to the MySQL site (which kirukan even pointed you to). Those links have several possible solutions.
  • You've been told to start mysql with force recovery enabled.
  • You've not done or tried any of the possible solutions, and don't even want to be bothered to read/understand what was posted.
We can't make things more plain. If you want someone to come type commands in for you, then you need to find a consultant and pay them. Otherwise, since you are the administrator, this will involve you showing some effort on your part. You seem to have left a production database down for about two weeks.
This is not an production database server.
 
Old 03-19-2013, 09:06 AM   #19
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 14,589

Rep: Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558
Quote:
Originally Posted by suresh.k View Post
This is not an production database server.
Not since it's been down for weeks it isn't. And again, have you tried/done ANYTHING that's been suggested to you?? The errors you posted tell you VERY CLEARLY, that you need to start MySQL with force recovery. You were given links on how to do it. Have you actually DONE IT YET???

From the MySQL forums, where you could have easily looked this error up weeks ago:
http://dev.mysql.com/doc/refman/5.5/...-recovery.html

Since you apparently don't want to read anything, the instructions on the page are VERY SIMPLE:
Quote:
Originally Posted by MySQL Website
For example, you can add the following line to the [mysqld] section of your option file before restarting the server:
Code:
   [mysqld]
   innodb_force_recovery = 4
That option file is the my.cnf file. You want to put in a "6".
 
Old 03-21-2013, 12:38 AM   #20
suresh.k
Member
 
Registered: Aug 2011
Location: Hyderabad, AP, India
Distribution: centos, Ubuntu
Posts: 163
Blog Entries: 1

Original Poster
Rep: Reputation: Disabled
Quote:
Originally Posted by TB0ne View Post
Not since it's been down for weeks it isn't. And again, have you tried/done ANYTHING that's been suggested to you?? The errors you posted tell you VERY CLEARLY, that you need to start MySQL with force recovery. You were given links on how to do it. Have you actually DONE IT YET???

From the MySQL forums, where you could have easily looked this error up weeks ago:
http://dev.mysql.com/doc/refman/5.5/...-recovery.html

Since you apparently don't want to read anything, the instructions on the page are VERY SIMPLE:

That option file is the my.cnf file. You want to put in a "6".
Thank you very much
I did it.
I added innodb_force_recovery = 6 in mysqld section in my.cnf file.

And i taken backup of all Databases and freshly installed mysql server.
Now it is Working fine.

Once Again thank you very much for your solutions.

Thanks
Suresh
 
Old 03-21-2013, 08:36 AM   #21
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 14,589

Rep: Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558Reputation: 2558
Quote:
Originally Posted by suresh.k View Post
Thank you very much
I did it.
I added innodb_force_recovery = 6 in mysqld section in my.cnf file.

And i taken backup of all Databases and freshly installed mysql server.
Now it is Working fine.
There was absolutely no reason to remove/reinstall MySQL. All you had to do is add the option to the file, which is what you were being told from the very beginning. Don't forget to remove it, since you don't normally want it to run.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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
How to login to mysql a4kata Linux - Newbie 1 09-13-2009 01:16 PM
MySQL - can't do much after login pellicle Linux - Server 23 07-27-2009 08:56 PM
Can not login into mysql. saudoi Solaris / OpenSolaris 1 11-30-2005 02:20 AM
mysql login Ab3n Linux - Newbie 2 07-04-2005 10:45 AM
mysql login sopiaz57 Linux - Security 1 01-05-2004 10:48 PM


All times are GMT -5. The time now is 05:18 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration