Solved

Fix corrupt mySQL 4.1 database

Posted on 2011-02-15
2
452 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
2 Comments
 
LVL 26

Expert Comment

by:ushastry
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

707 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now