MySQL Forums
Forum List  »  Newbie

Re: Corruptions like crazy
Posted by: John Bowles
Date: April 30, 2015 08:59AM

Another thing that I think might be important.

Twice I think I have been forced too run a backup then a return with phpMyAdmin because the myisamchk program was saying all errors had been fixed yet my website page run would kick out an error when the PHP ran the MySql command to insert the record. After this live MySql error occurred I would run the myisamchk program again and it would say there were no errors. In this situation I was obviously stuck and had to run the backup and return (or just return the last backup). So this fixed the problem. Then I would do an add to the database with my webpage and I would get errors like below. Now if I choose to not fix these errors with the -r option I could just keep on adding more and more records with my webpage and the errors below would not change. But if I decide to fix the errors below with the "myisamchk -r" run and after that I try to add records with my webpage I would get the full corruption errors for the three files as shown in the prior post.



myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/MyTable1.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/MyTable2.MYI' is usable but should be fixed
myisamchk: warning: 1 client is using or hasn't closed the table properly
MyISAM-table '/var/lib/mysql/musiciansjamnetwork/MyTable3.MYI' is usable but should be fixed

Options: ReplyQuote


Subject
Written By
Posted
April 29, 2015 11:33AM
April 29, 2015 11:49AM
April 29, 2015 12:20PM
April 29, 2015 12:40PM
April 29, 2015 01:04PM
April 29, 2015 01:36PM
April 29, 2015 01:48PM
April 29, 2015 02:00PM
April 29, 2015 02:59PM
April 29, 2015 03:30PM
April 29, 2015 04:24PM
April 30, 2015 07:44AM
April 30, 2015 07:48AM
April 30, 2015 08:44AM
April 30, 2015 08:57AM
Re: Corruptions like crazy
April 30, 2015 08:59AM
April 30, 2015 09:40AM
April 30, 2015 10:19AM
April 30, 2015 01:45PM
April 30, 2015 02:42PM
April 30, 2015 03:36PM
April 30, 2015 07:36PM
April 30, 2015 10:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.