473,326 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Corrupt read only tables

How can a read only MYISAM table become corrupt?

I have to do a myisamchk -r approx. once a week as the table gets marked as crashed.

I can't see how this is happening though as no changes are being made to it, it's read only.

It's running on mysqld-nt version 5.0.51b, the same table running on a mac and a linux box have not done this, so far.
May 27 '15 #1

✓ answered by loganwatts

The recovery plan is following:
Split corrupted InnoDB tablespace into pages; sort the pages by type and index_id
Fetch records from PRIMARY index of the table
DROP corrupted table and create new one
Load records back into MySQL

Also you may visit the branch where the similar issue was resolved http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=196415

4 1646
RonB
589 Expert Mod 512MB
Hard drive beginning to crash?

14.1.4.1 Corrupted MyISAM Tables
May 27 '15 #2
RonB
589 Expert Mod 512MB
That's an old version. Personally, I'd upgrade to the latest version (5.6 or 5.7) and convert the table(s) to InnoDB.
May 27 '15 #3
The recovery plan is following:
Split corrupted InnoDB tablespace into pages; sort the pages by type and index_id
Fetch records from PRIMARY index of the table
DROP corrupted table and create new one
Load records back into MySQL

Also you may visit the branch where the similar issue was resolved http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=196415
May 27 '15 #4
computerfox
276 100+
Can you find the log files? Usually there's something in there. What machine is it crashing on, Windows? As Ron said, make sure it's up to date. Also, you might have to create a copy of the table and transfer the data over.
May 27 '15 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: RAF | last post by:
i'm trying to make report using dataset having two tables in viewer page iam doing rpt.SetDataSource(ds.Tables(0)) rpt.SetDataSource(ds.Tables(1)) CrystalReportViewer1.ReportSource = rpt ...
4
by: aaj | last post by:
Hi all I have been given a corrupt access 2000 backend and asked to salvage the data.(youve gussed it, no backup) On trying to open it just kicks me out saying its not a valid database file -...
5
by: Grzegorz Danowski | last post by:
Hi I have two databases: Customers and Operations. In Customers database I have made a view based on a few tables from both Customers and Operations (left join - customers without any...
0
by: saudakhan | last post by:
Hi, I have a wierd XML file <Ins> <HomeP> <RqUID>SomeRqUID1</RqUID> <Trans>2006-02-17</Trans> <HomeL> <LOB>HOME</LOB> <Producer>
1
by: nikfa | last post by:
Dear All, your discussions are really interesting. I work with Ms Access but as many efforts I make to protect the DB as same results I obtain. I 've been told your work group is very cool in...
0
by: Gian Paolo | last post by:
ok i made this but now i don't know how to retrive the values contained in the tables of the ds dstaset someone han help????? using System; using System.Collections.Generic; using...
1
by: keyjen2017 | last post by:
i am trying to read the table in DB2 using JAVA code. then it is supposed to be copied in .txt file. how can i do this? other thing, i m passing date in dddd-mm-yy format from JAVA codeto call a ...
5
by: anuragpj | last post by:
I have to get all the table names that exist in a particular database in pgsql and print it in a html page. How can i do this?
0
by: wshibl | last post by:
I have a lot of files that have the same below format in different folders and I need to parse these files and add them in one file : X1 = 1 X2 = 2 X3 Y1 Y2 0.005 ...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.