I am using S3 for my database backups, cause it is cheap and it worked quite well, but the database got bigger and bigger. So I tried to optimize the process, with success.

MySQL/MariaDB are popular Databases, which are often used for data scraping, because they can handle a lot of INSERTs in a short time. In this post I will show you how to add a new user and set the permissions to access a database.

I had some troubles re-installing mariadb - files were missing and old installation files were used. Here are the steps how I optimised the configuration and changed the data-dir.