Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is a Raw backup?

backup raw
0
Posted

What is a Raw backup?

0

• Raw backup provides a consistent copy of the database by storing a binary copy of the data files. There are several advantages of raw backups over logical backups: • Backup and especially recovery are much faster. For example, it not unusual to see that for the very same database the raw backup is 5-10 times faster than the logical backup, and recovery of the raw backup image is 20 times faster than recovery of the logical backup. • Because it is simply a copy of the database files, a raw backup has a predictable size. • It provides better scalability than logical backup, which could be important if your MySQL database is rather large, for example, 10-20 GB or more. • The disadvantage is that raw backups can be recovered only to the same version of MySQL server running on the same operating system as the original data files.

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.