# How long would it take to backup/restore a 170GB database
**URL:** https://forums.percona.com/t/how-long-would-it-take-to-backup-restore-a-170gb-database/14676
**Category:** General Questions
**Tags:** mysql
**Created:** [March 9, 2022, 4:06pm UTC](https://forums.percona.com/t/how-long-would-it-take-to-backup-restore-a-170gb-database/14676 "2022-03-09T16:06:51Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Michael\_Peters](https://forums.percona.com/u/Michael_Peters)
#### Post date: [March 9, 2022, 4:06pm UTC](https://forums.percona.com/t/how-long-would-it-take-to-backup-restore-a-170gb-database/14676/1 "2022-03-09T16:06:51Z")
My customer has a 170GB MySQL database on a Linux server. The database is usually only used during the day, by maybe 30 logged in users per day, using a Lucee application.
The provider does a MySQLDump of the database every day which is better than nothing. But judging from my experience with the 10GB database of another customer, a restore of a 10GB MySQLDump database can already take hours. Restoring this customer’s 170GB database in an emergency situation would probably take days which is unacceptable.
So we are planning to set up a Percona backup/restore, hoping it will perform much faster but it would be good to know beforehand what we can expect. How long would a backup take? and more important: how long would a restore take?
---
### Author:  [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [March 9, 2022, 4:44pm UTC](https://forums.percona.com/t/how-long-would-it-take-to-backup-restore-a-170gb-database/14676/2 "2022-03-09T16:44:39Z")
> [@Michael\_Peters](#):
>
> How long would a backup take? and more important: how long would a restore take?
It depends. 😄
Seriously, it depends on what type of disks you have (HDD/SDD/NVME/Flash/etc), how much CPU capacity you have, what the configuration of MySQL is, etc, etc.
You can benchmark the read capacity of your your disks to get a sense of how long it will take to backup, and then benchmark the write capacity to get a sense of restore.
Physical backups, like Percona Xtrabackup, will always be magnitudes faster than logical dumps.
mysqldump is the worst due to its single-threaded nature. You should look at [GitHub - mydumper/mydumper: Official MyDumper Project](https://github.com/mydumper/mydumper) for far faster logical dump/restore, but Xtrabackup is still going to be the fastest.
---
### Author:  [@katajistok](https://forums.percona.com/u/katajistok)
#### Post date: [March 9, 2022, 6:01pm UTC](https://forums.percona.com/t/how-long-would-it-take-to-backup-restore-a-170gb-database/14676/3 "2022-03-09T18:01:35Z")
Database restore of 200GB+ to Server which has 3.2TB NVME SSD from Ceph storage (spinning disks) within the same datacenter ~1 hour using xtrabackup or Percona Distribution for MySQL Operator.
Best way to find out is to test out.