Primary hard disk where MySQL (version 5.1) was installed is crashed and I had to re install entire OS. I have all the files including ibdata1 file. How do I go about recreating and attaching database to restore it to stage where it was crashed. Do i need log files or I can delete them ?. I am OK if some of the data I cannot restore. Important is I have all tables and most of the data possible.
Mysql – How to restore MySQL database from Files
mysql-5.1restore
Related Question
- Mysql – find out what version of MySQL from the data files
- Restore a WordPress database from .frm and .idb only
- How to restore operational Oracle 11g Database from full backup
- Sql-server – Disk Crashed, NDF(Index) file lost
- Mysql Daemon cannot start after upgrade from 5.1 to Mysql 8
- Is it possible to attach Oracle database files after a clean install
- Mysql – How to set up thesql docker container with existing ib* files
Best Answer
DB_NAME_RESTORE
/var/lib/DB_NAME_RESTORE
and copy the data files therechmod
on the files if you have to