Mentioned about the Mysql Data, do you know Where Does MySQL Stored the Data in Harddisk?
Firstly, I will talk about the data in the windows:
1) Locate the my.ini, which store in the MySQL installation folder.
C:\Program Files\MySQL\MySQL Server 5.1\my.ini
2) Open the "my.ini" with our favor text editor.
Find the "datadir", this is the where does MySQL stored the data in Windows.
Secondly, I will talk about the data in the Linux:
1) Locate the my.cnf with the find / -name my.cnf command.
2) view the my.cnf file cat /etc/mysql/my.cnf
3) Find the "datadir", this is where does MySQL stored the data in Linux system.
When the harddisk is corrupted, the Mysql Data is lost. If you still need them, you can recover it.
How to Recover Mysql Data Easily?
1. Download OSpeedy Data Recovery and install it.
2. Activate and start OSpeedy Data Recovery.
3. Select the document from which the file you wish to recover was deleted or formatted.
4. Click "Scan". OSpeedy Data Recovery could search the files that exist in hard drive sectors that are flagged to be overwritten.
5. Choose the file you want to recover in the listing of files that OSpeedy Data Recovery finds.
6. Click "Recover" and to see if the file is available once again in its original location.
What the OSpeedy Data Recovery Can Help You?
Express Recovery - Recover deleted files quickly.
Advanced Recovery - Raw recovery, provides a complete and further recovery which can recover more files but will take more time. You need a disk with large capacity.
Partition Recovery - Retrieve corrupted or lost partitions, with all data intact.
These three types of the functions are main characteristic. Besides recovering mysql data, it can fix these situations:
Accidental Deletion Events
Delete -- "Shift + Del" key entry (with no prior backup)
"Delete All" selected in error
Selected "Delete" instead of "Save"
Recycle Bin erroneously emptied (and no backup)
Accidental Formatting or Reformat (examples of recoverable events)
Formatted Media/Device in error
Initialized target storage when memory card newly connected
Storage device accidentally formatted
Improper Operation
Factory reset
Powered off device (camera etc.) during write process
Card mistakenly used in different cameras
SD Card removal while device is powered on
This is all about "How to Recover Mysql Data Easily". Hope it helps. Thanks for reading.