filmov
tv
Restore MySQL database from data files

Показать описание
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
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
Backup and Restore MySQL Databases using MySQL Workbench [2022]
How to Restore Old MySQL Database to New XAMPP Installation [Tutorial]
How to restore mysql database using files on data folder? (2 Solutions!!)
Back Up and Restore MySQL Databases Using MySQL Workbench
Back Up Your MySQL Databases! (Spoiler: It's Easy)
Backup MySQL Database - Use SQL and PHPMyAdmin to backup and restore a database
How To Backup and Restore MySQL Database
MySQL Tutorial - 40 - BACKUP & RESTORE MySQL Database
What’s New in MariaDB: Performance, Security, and Beyond | Mydbops Webinar Edition 43
How to Restore Database from backup in MySQL Server - MySQL DBA Tutorial
How to Restore sql database in mysql workbench#shorts
How to backup and restore MySQL database?
Restore single MySQL table from a full mysqldump backup file - MariaDB Tutorial
Restore MySQL database with MySQLdump (from the command line)
How to recover mysql database from data files in windows/ xampp using .ib/.frm/.ibd files(Step-wise)
UNLOCK THE SECRET TO AUTOMATICALLY BACK UP AND RESTORE YOUR MySQL DATABASE WITH COMMAND PROMPT
Back up and restore MySQL databases using MySQL Workbench 6 or 8
RECOVERING MYSQL DATABASE FROM DATA FOLDER BACKUP
How to RESTORE A DATABASE BACKUP FILE (.BAK) in SQL Server 2016
Restore Database Using MySQL Administrator
How To Recover A Dropped MySQL Database From The Binary Logs
Using MySQL Workbench to backup your database
How to restore single database from complete MySQL database dump - MySQL DBA Tutorial
How To Restore Mysql Database Using Visual Basic .Net 2022
Комментарии