Recovering corruption issues while using mysqldump utility in MySQL database

Recovering corruption issues while using mysqldump utility in MySQL database

Recovering corruption issues while using mysqldump utility in MySQL database

Free Online Articles Directory

Why Submit Articles?
Top Authors
Top Articles
FAQ
ABAnswers

Publish Article

0 && $.browser.msie ) {
var ie_version = parseInt($.browser.version);
if(ie_version Login

Login via

Register
Hello
My Home
Sign Out

Email

Password


Remember me?
Lost Password?

Home Page > Computers > Data Recovery > Recovering corruption issues while using mysqldump utility in MySQL database

Recovering corruption issues while using mysqldump utility in MySQL database

Posted: Dec 31, 2010 |Comments: 0
|

]]>

The mysqldump  utility is a MySQL database backup program that enables you to copy (or dump) a database to another SQL Server. This server may not necessarily be another MySQL Server. On most occasions, the MySQL dump contains SQL statements that are used to create tables and insert records in them. You can generate the data in the mysqldump utility in CSV or XML format as well. However, sometimes you are unable to use this utility to dump the database. Such problems can occur due to corruption in the database. The database corruption can occur due to various reasons such as virus infections, power outages, bugs in MySQL version, hardware issues, etc. In such cases, you should find out the cause of the problem and try to resolve the issue. If you are unable to fix the error, then you should use a third-party MySQL repair software to perform MySQL recovery.

Consider a scenario wherein you are working on a MySQL database in which you want to dump a MySQL database to another location. However, you are unable to dump the database and an error message is displayed, that is:

[root@www diaendomet]# mysqldump -ucojjohealth -p –all-databases >

alldatabases.sql

Enter password:

mysqldump: Got error: 29: File ‘../diaendomet/users.MYD’ not found

(Errcode: 2) when using LOCK TABLES

Cause:

The primary cause of this erroneous situation is that the MySQL database is corrupted. It has corrupted due to any of the various reasons discussed in the introductory paragraph.

Resolution:

To resolve the situation, you should perform the following steps:

* Stop the MySQL server.
* Change the working directory to $MYSQL_DATA_DIR
* Run the myisamchck utility as displayed: run myisamchck with */*.MYD. This command will complete a check on all the table files and repair wherever it finds any error.
* Restart the MySQL server and try to repeat the database dump. It should run fine now.

However, there may be instances when this resolution does not provide the solution to the problem. This would invariably mean that the database is severely corrupted. In such cases, you should use a third-party MySQL recovery software to repair MySQL database. Such MySQL repair tools are read-only in nature that do not overwrite the existing database while performing MySQL recovery.

Stellar Phoenix Database Recovery for MySQL is a MySQL repair software that is able to repair MySQL from all instances of logical corruption. It is able to recover MySQL database components such as tables, queries, etc. This MySQL recovery utility supports InnoDB and MyISAM database engines. It is compatible with Windows 7, Vista, Server 2003, XP, and 2000. In addition, this MySQL repair software is specifically designed to recover MySQL databases created in MySQL 4.x and5.x.

Retrieved from “http://www.articlesbase.com/data-recovery-articles/recovering-corruption-issues-while-using-mysqldump-utility-in-mysql-database-3947855.html”

(ArticlesBase SC #3947855)

Watch your traffic increase just by submitting articles with us, click here to get started.
Liked this article? Click here to publish it on your website or blog, it’s free and easy!

Mark Willium
About the Author:

Mark Willium is a database expert doing research on MySQL repair software. For more details visit: http://www.mysql-database-recovery.com/

]]>
Questions and Answers

Ask our experts your Data Recovery related questions here…

Ask

200 Characters left

I use Google chrome and the tutorial is for firefox. Iv tried downloading games but they all come up as corrupt files! I use the utorrent and save the files to my psp save data! what am I doing wrong?
What are the ethical issues surrounding the use of interns ?
I have a satellite direct account and registered,have trouble getting on it cause it says i have multiple subscription on another p.c.,but i dont,only the one i am using

Rate this Article

1
2
3
4
5

vote(s)
0 vote(s)

Feedback

Print

Re-Publish

0) {
ch_selected = Math.floor(Math.random()*ch_queries.length);
if(ch_selected == ch_queries.length) ch_selected–;
ch_query = ch_queries[ch_selected];
}
}catch(e){
ch_query = document.title;
}
]]>

Source:  http://www.articlesbase.com/data-recovery-articles/recovering-corruption-issues-while-using-mysqldump-utility-in-mysql-database-3947855.html

Article Tags:
mysql repair, mysql recovery, mysql database repair, repair mysql, recovery mysql, mysql database recovery

Related Videos

Related Articles

Latest Data Recovery Articles
More from Mark Willium

How to create a MySql database

How to create a MySql database using your domain manager. I’m using cPanel. This is used to set up a WordPress blog. http://www.websitetechnician.com
(02:23)

How to Take WordPress Database Backup – Part 2

There are different methods to take backup of your wordpress database. Most probably your database will be accessible in your cpanel at MySQL option. You may have phpmyadmin also in your cpanel database section. If you have phpmyadmin, you can easily access your database. Yes. The backup process also here easy. Just you have to export your database table records (03:13)

Dreamweaver CS3 and ColdFusion – How to Install the MySQL Database Program

Learn about installing the MySQL Database Program in this Adobe Dreamweaver CS3 Advanced training video series. (00:42)

How to Install phpMyAdmin 3.1.2 for Windows MySQL Apache Server

This tutorial explains how to install phpMyAdmin for Windows so you can control your MySQL database server. (05:21)

Fixing WP MySQL Crashed Tables

This short video showshow to repair a crashed table in your wordpress mysql database, as well as how to fix MySQL table overheads, just in case your blog ever suffers one like mine did.. (04:50)

MS Access Database corruption after migrating it to MySQL

Stellar Phoenix Access Recovery is a powerful and trust worthy Access Repair tool which can restore and Repair Access database objects such as tables, queries, forms, reports, macros and modules. The read only repair tool is compatible with Microsoft Access 2007, 2003, XP (2002) and 2000. The repair utility supports Windows Vista, XP, 2003, 2000 and NT operating systems.

By:
colindollyl

Computers>
Softwarel
Jul 23, 2009

How to repair MySQL database when the Error 145 occurs

In MySQL databases, the MyISAM table is the default database engine, which provides a variety of functions to manage fields and indexes.

By:
Mark Williuml

Computers>
Data Recoveryl
Dec 21, 2010

Comments are closed.