LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > LinuxQuestions.org > Linux - News > Syndicated Linux News
User Name
Password
Syndicated Linux News This forum is for the discussion of Syndicated Linux News stories.

Notices



Reply
 
Search this Thread
Old 05-12-2008, 12:30 PM   #1
LXer
LXer NewsBot
 
Registered: Dec 2005
Posts: 76,286

Rep: Reputation: 87
LXer: Recover a MySQL Table with Zmanda Recovery Manager


Published at LXer:

If somebody accidentally drops a critical table in MySQL, the application no longer works. The solution to this problem is to utilize the (open source) Zmanda Recovery Manager. You are a MySQL database administrator. You take regular backups of your MySQL database. Somebody drops a table critical to the MySQL application (for example, the "accounts" table in a SugarCRM application). The MySQL application no longer works. How can you recover from the situation?The answer is MySQL binary logs. Binary logs track all updates to the database with minimal impact on database performance. MySQL binary logs have to be enabled on the server. You can use the mysqlbinlog MySQL command to recover from the binary logs.

Read More...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Zmanda Delivers First Enterprise Backup Software for Ubuntu LXer Syndicated Linux News 0 11-14-2007 07:30 AM
LXer: Zmanda Recovery Manager for MySQL Now Available for Ubuntu LXer Syndicated Linux News 0 12-21-2006 12:54 AM
LXer: MySQL Backup And Recovery With mysql-zrm On Debian Sarge LXer Syndicated Linux News 0 09-28-2006 09:21 AM
Recover a file saved in a mysql table via php upload prabhatsoni Linux - Software 0 07-13-2006 08:49 AM
LXer: Mysql Cluster 5.0 ALTER TABLE In-Depth LXer Syndicated Linux News 0 07-08-2006 11:21 AM


All times are GMT -5. The time now is 10:53 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration