MySQL database backup from bad disk

Asked By jami daub 0 points N/A Posted on - 10/05/2012

Hi Experts,

I am looking for backup software, I need to create mysql database backup from bad disk. My hard disk is very old and it will crash any time, so please send me how can create mysql database backup from bad disk. Please send me the proper solution. Thanks!    

Regards,    

Jami Daub

• Status: Open
• Question Views: 1019
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Dyer Pearlman

Go To Solution

Answered By Goram Ian 60 points N/A #171812

MySQL database backup from bad disk

Hi Jami Daub,

 

I prefer you go to different sites or forums to gather more information regarding with this matter. I refer the links of  forums below because it has a lot of information that you need.

 

CPANEL Forum: Backup all Databases when mySQL not running

Porteus Forum: URGENT – Porteus RESCUE MySQL Backup

Hope that it would solve your problem.

Thanks.

About Goram Ian

Questions
1

Answers
399

Best Answers
96

• Vote Up 0 Vote Down

• Posted on - 10/18/2012
• Question Category: MySQL Server

Best Answer

Best Answer

Answered By Dyer Pearlman 0 points N/A #171814

MySQL database backup from bad disk

Hello Jami,
To backup Mysql database, you will need to have proper permission (administrative) to be able to access the Mysql Database Server.  You can download Mysql – Workbench tool (mysql-workbench-gpl-5.2.47-win32.msi) from https://dev.mysql.com/downloads/tools/ site. This tool is free to download and use. The tool requires
“Microsoft .NET Framework 4 Client Profile (Web Installer) “ which can
be downloaded from https://www.lullabot.com/articles/mysql-backups-using-lvm-snapshots website for free. You will need to install this tool.
Install the  .Net Framework 4 client profile, then install mysql-workbench. After successful installation of Mysql Workbench follow below steps to backup your database:
a) Double Click the “MYSQL WorkBench” program, this can be done from the start menu in windows 7 or xp.
b) You have to make sure that mysql database server is running.
c) After MYSQL WorkBench starts, click on “Database” Menu, Select “Manage Connections” submenu. Provide the necessary connection details.
d) After you are done with Connection Settings, click on “Manage Import/ Export” .
e) The above action will open a window with a list of databases currently
available in your server. Select the database that you want to export
and also remember to select location to save your exported files.
 

About Dyer Pearlman

Questions
3

Answers
102

Best Answers
62

• Vote Up 0 Vote Down

• Posted on - 05/18/2013
• Question Category: MySQL Server