What are the different ways to restore a database? From the most inoffensive of the cases, to the worst of the scenarios they know. What are the different ways to restore or recover a MySQL database? I refer to the use of full backups and incremental backups, among other ways to do it. I do not know if it can be done through ibdata and iblogfiles, is what I need to know ... Thanks in advance.
Backup scenarios are designed around the risk profile. These include resilience and time to restore as the most critical factors.

The backup needs to account for the potential risks to be encountered including physical destruction, a malicious insider, a technological competent criminal, or a sever database flaw.

Backups will include offsite/offline backup based on risk assessment.

Backups can include a bunch of logical (SQL dumps), and binary backups (copy of the entire datadir based on stopped server or xtrabackup), binary logs for point in time recovery, and can frequently involve a replication slave to assist with such mechanisms.