Recovery tool for linux Mysql database.

Hi,

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

Good tool required urgently.




LVL 18
Sam PanwarSr. Server AdministratorAsked:
Who is Participating?
 
cjl7Connect With a Mentor freelance for hireCommented:
Hi,

mysqldump - take backups of your system

mysql - restore your backups...

or...

Use mysqladmin

http://dev.mysql.com/downloads/administrator/1.1.html

//jonas
0
 
Sam PanwarSr. Server AdministratorAuthor Commented:
No we need rpm which recover our data .

I know abt back up.
0
 
sodap0pConnect With a Mentor Commented:
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....
0
 
cjl7freelance for hireCommented:
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...)

//jonas
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.