Recovery tool for linux Mysql database.

Posted on 2006-05-16
Last Modified: 2013-11-13

I have required recovery tool for linux My sql files, which is work on online environment.

Good tool required urgently.

Question by:Sam Panwar
    LVL 14

    Accepted Solution


    mysqldump - take backups of your system

    mysql - restore your backups...


    Use mysqladmin

    LVL 18

    Author Comment

    by:Sam Panwar
    No we need rpm which recover our data .

    I know abt back up.

    Assisted Solution

    Is your entire DB corrupt or do you have corrupt tables? In most cases, you will encounter a corrupt table, for which you can use one of the following tools:

    this command can be run while the database is up
    * log into mysql and run: REPAIR TABLE yourtablename;

    this command only works on MyISAM tables and can be run while the database is up
    * from the command line, run: mysqlcheck -r yourdatabasename yourtablename -uusername -ppassword

    In the unfortunate event that the database files were deleted, or something of that nature, you would have to restore from some sort of backup....
    LVL 14

    Expert Comment

    Well in order to recover data you need to backup that data first...

    If you want a backup-solution (Legato Networker, Veritas Netbackup, Arkeia, amanda, baccula) are some of your options.

    But they are not cheep/simple/included...

    In any case they would still have to use mysqldump in order to backup the data... (that's the only way of doing online backups)

    (NOTE: yes, I know you can do it using sql but that is not really an option...)


    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    Setting up Secure Ubuntu server on VMware 1.      Insert the Ubuntu Server distribution CD or attach the ISO of the CD which is in the “Datastore”. Note that it is important to install the x64 edition on servers, not the X86 editions. 2.      Power on th…
    You ever wonder how to backup Linux system files just like Windows System Restore?  Well you can use Timeshift in Linux to perform those similar action.  This tutorial will show you how to backup your system files and keep regular intervals. Note…
    Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
    Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

    730 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

    16 Experts available now in Live!

    Get 1:1 Help Now