Category Database

install-and-use-postgresql-in-arch-or-manjaro-with-php

Install and use PostgreSQL in Arch or Manjaro with PHP

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.

September 2, 2022

recover-innodb-mysql-or-mariadb-database-from-raw-files

Recover InnoDB MySQL or MariaDB database from raw files

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.

June 25, 2022

upgrade-to-mariadb-10-6-on-ubuntu-20-04

Upgrade to MariaDB 10.6 on Ubuntu 20.04

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.

May 11, 2022

backup-restore-mysql-mariadb-databases

Backup and restore MariaDB/MySQL databases

Every database running a site should have backup system. We will explore how to backup and restore MariaDB/MySQL databases in this article.

October 17, 2021

mysql-mariadb-restore-corrupt-database

Fix MySQL/MariaDB corrupt database

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.

October 12, 2021