I have many MySQL databases with many tables and I’m trying to figure out if I can restore all of it only using the content of my MySQL data folder.
Or should I just not bother and use the following instead?
mysqldump --all-databases > db_backup.sql
Mysql – Restore MySQL tables with data folder only
disaster recoveryMySQLmysqldump
Related Question
- MySQL – How to Recover or Restore Corrupted InnoDB Data Files
- Mysql – thesqldmup with data only
- MySQL Backup – Restore Database with Only .frm Files
- Mysql – How to restore MySQL databases from database files
- MySQL Data Corruption in VirtualBox with Shared Folder
- Mysql – Unistalled MySQL 5.6 and installed MySQL 5.7 – Restore Database and Tables
- MySQL – Restore Mysqldump to Different Database Name on Same Host
Best Answer
You cannot move a single table or database around via the filesystem.
If you have the entire folder, then there is a pretty good chance of being able to move (or restore) all databases.
ibdata1must be included