How to restore Database using ibd frm files and data files
Hello folks,
I have a scenario where we have all files in data directory (var/lib/mysql/DB_NAME) available. I dont have dump utility to collect the dump of entire database. Now using these files how can I replicate DB in other system? We have innodb_file_per_table on.
1. What all files from data directory are needed? I know we need -ibdata1, -ib_logfile0 and -ib_logfile1 and frm files as well. Do we also need ibd file for each table? Or any other file?
2. If we stop mariadb service, just copy these files to data directory in newly installed system and restart mariadb again, Will it work and replicate the database?
3. If we can restore the database, how can we check the DB for integrity as check/repair is not meant for InnoDB tables?
Appreciate any help in this regard.
Answer Answered by Ian Gilfillan in this comment.
Take a look at https://dev.mysql.com/doc/refman/5.6/en/innodb-migration.html as the same applies to MariaDB.