The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

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.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.