Solved

Fix corrupt mySQL 4.1 database

Posted on 2011-02-15
2
454 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Multilanguage Database Design in MySQL 5 119
User with DBO permission can't remotely connect 15 50
updating the date data 12 30
MySQL  on Tomcat 8 47
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

831 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