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

MariaDB restore time

Hi All,

We have a customer who have Mariadb databases on his Linux servers. We are moving his databases from old server to new AlmaLinux servers. One of the Mariadb database backup file size is 162 GB, few other backup file sizes are more than 50 GB

It took more than a week to complete the restoration of database backup file which is of size 162 GB

I read an article where it was suggested to set value of FOREIGN_KEY_CHECKS and SET UNIQUE_CHECKS to 0 in MariaDB configuration so I set it to 0 but it did not help to speedup restoration time

Does it really take more than a week to restore database backup file of size 162 GB ? is it normal or do you think its taking long time to restore it ?

Server have much better specification that is 64 GB DDR4 RAM, 16 core CPU with SSD disks

Your thoughts on this are much appreciated !

Many Thanks

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.