Recover a MySQL Table with Zmanda Recovery Manager

Posted by Scott_Ruecker on May 12, 2008 7:56 AM EDT
Linux Journal; By Paddy Sreenvasan 		Mail this story
Print this story

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.

Full Story

  Nav
» Read more about: Story Type: News Story; Groups: Linux, MySQL

« Return to the newswire homepage

Subject Topic Starter Replies Views Last Post
And for PostgreSQL ... DarrenR114 9 1,710 May 15, 2008 8:02 AM

You cannot post until you login.