I would not go into details of what is PostgreSQL as I am pretty sure you already know about it. But in this guide, we will install and use PostgreSQL in Arch or Manjaro operating system with PHP including how to manage the databases.
So you have raw files of your database and don't have a dump or backup at hand. Worry not, it's easy to recover an InnoDB MySQL or MariaDB database from raw files.
Today I am going to show you how to upgrade to MariaDB 10.6 on Ubuntu 20.04 and backup-restore the databases in the process.
Every database running a site should have backup system. We will explore how to backup and restore MariaDB/MySQL databases in this article.
We will fix/restore a MySQL/MariaDB corrupt database. Before going to the details, we will make sure to take backup of the data files.