-
Which of the following is the final method to create MySQL backups?
-
- File backups
- CSV backups
- SQL backups
- LVM snapshots
- None of these
Correct Option: A
Copy of data or else database is known as backup. The final method for creating MySQL backups is LVM snapshots. It uses a copy-on-write feature of storage systems in which LVM i.e. Logical Volume Management is the most popular in Linux. It is very quick as it creates the snapshots. CSV stands for Cluster Shared Volumes backups. File backup is the backup of MySQL database which creates a copy of files from MySQL data directory. SQL backups are alternate to File backups.