Solved

Fix corrupt mySQL 4.1 database

Posted on 2011-02-15
2
457 Views
Last Modified: 2012-05-11
Hi, I have an install of mySQL4.1 and the mySQL service keeps stopping after a minute or so.

If I cut and paste a particular database out of the data folder, the mySQL service starts without issue.

How can I repair this corrupt database?
0
Comment
Question by:Tech Man
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 26

Expert Comment

by:Umesh
ID: 34904188
Hi!

Please post the error log and config file(make sure you hide all IP/Password related info from config file)
0
 
LVL 1

Accepted Solution

by:
DokKlaus earned 500 total points
ID: 34904299
you can use the mysqlcheck & mysqlrepair functions included in mysql.
here is the doc page for mysql 4.1 repair http://dev.mysql.com/doc/refman/4.1/en/repair-table.html 
0

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question