MySQL database backup from bad disk

Asked By 0 points N/A Posted on -
qa-featured

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

SHARE
Best Answer by Dyer Pearlman
Answered By 0 points N/A #171812

MySQL database backup from bad disk

qa-featured

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.

Best Answer
Best Answer
Answered By 0 points N/A #171814

MySQL database backup from bad disk

qa-featured

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 http://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 http://www.lullabot.com/blog/article/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.
 

Login/Register to Answer

Related Questions