[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

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.




0
Sam Panwar
Asked:
Sam Panwar
  • 2
2 Solutions
 
cjl7Commented:
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
 
sodap0pCommented:
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
 
cjl7Commented:
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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now