#Mysql enterprise backup restore data how to#

The data loading process is longer, as almost 4 Gb of data must be processed, but in the end, the result is achieved: Data restored Restoring from HeidiSQLР”Р„nother alternative for data restoration is to use the database manager itself, both MySQL WorkBench and HeidiSQL. But now, letРІР‚в„ўs restore the data by using the DATA file as well: Restoring the data The structure of the database has been restored with no problems. LetРІР‚в„ўs move into HeidiSQL to see whatРІР‚в„ўs going on: Database restored LetРІР‚в„ўs open a console, and move to the path where the backupРІР‚в„ўs database are stored, and from there, letРІР‚в„ўs call mysql, writting this sentence: Restore of a database from. On other hand, I am working with MariaDB from d:/mariadb. sql backup files located in D:/backupsolar/20200618, which is where we have made the copies of different databases, separating the structure (STRU files) from the data (DATA files). In the case shown in this entry, we will load the inst1 data, from some. I am not going to make any script for this because it is more feasible to do this process manually. Restore a backup with mysql in MySQL or MariaDB Our database is ready and the backup of the databases is ready too. My actual situation is like this: MariaDB 10.4 before restoring I have also shown you in several entries that, from files, you can have MySQL 8 or MariaDB 10.4 (although you can do exactly the same for other versions).

To do this, it may be a good option to try with some empty database. Today another fundamental part of backups is to prove that they work.

#Mysql enterprise backup restore data how to#

In the previous entry I showed you how to work with a custom script to make the copies, and that you can include in your Windows Startup to run automatically every time you access your computer, or launch it from a scheduled task, or when you need it. We continue to learn things about databases, and this time, itРІР‚в„ўs time to restore the backups weРІР‚в„ўve made of our MariaDb or MySQL databases.