Solved

Fix corrupt mySQL 4.1 database

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
change database name 2 40
Insert values are dynamic 11 60
remote mysql 8 40
MySQL limit and not so limited 13 41
I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Creating and Managing Databases with phpMyAdmin in cPanel.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 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