Restore MySQL database from data files

Published: 05 July 2018
on channel: Anar Jafarov

4,653

Tried to make small experiment on recovering database structure and if possible table contents from crashed database server.
P.S. To avoid watching long video, You can click on time-codes in description.

Steps:
1. move .frm, .ibd files from mysql data directory
2. drop database and create a fresh one
3. create tables using mysqlfrm tool 01:15
4. discard tablespace from table 07:25
5. copy .ibd files to mysql data directory 09:20
6. import tablespaces 12:40
7. restart mysql

Hope You'll enjoy it and will have patience to watch it.
I tried my best from "first filming shot" :D

On this page of the site you can watch the video online Restore MySQL database from data files with a duration of hours minute second in good quality, which was uploaded by the user Anar Jafarov 05 July 2018, share the link with friends and acquaintances, this video has already been watched 4,653 times on youtube and it was liked by 25 viewers. Enjoy your viewing!