1. Use of MariaDB Backup Tools: Several efficient backup tools like Percona XtraBackup, MariaDB Backup, etc., are available that allows to take MariaDB’s full backup. So, if you lose any data accidentally, you can recover it from the backup quickly.
1. Binary Log Point-in-Time Recovery: This is another way to recover lost data in MariaDB. It helps if you need to roll your database back to a particular point in time.
Here are the steps:
a. Stop the MariaDB Server: systemctl stop mariadb b. Restore a full backup: mysql -u root -h localhost -p < /path/yourdatabase.sql c. Execute this command to convert binary files to SQL statement: mysqlbinlog —start-datetime=“2023-06-26 12:59:00” \\ —stop-datetime=“2023-06-28 13:59:00” \\ /var/log/mysql/mariadb-bin.000001 > /tmp/statements.sql d. Now import this statement: mysql -u poll -h localhost -p Protozoa < /tmp/statements.sql1. Use of Recovery Tools: There are recovery tools available that can recover the data from crashed MariaDB such as Aria. You can use those tools to recover the data.
However, ideally, one should always have a backup for your database, enabling you to recover from any data loss scenario easily.
