Latest Post
How to Analyze PostgreSQL Table Size
When your database becomes large, you'll want to dig further and see what tables is using space and identify if how to optimize this.\ This…
How to Restore a MySQL Dump
October 18, 2023
A MySQL backup is a copy of your database data (also known as MySQL dump) that you can use to restore your database in case of data loss…
Extensive MySQL Common Errors List
November 16, 2023
Errors or mistakes are common in any aspects, especially in development. Using MySQL or any database can't guarantee you an error-free…
Mounting DigitalOcean Spaces and Access Bucket From Droplet
June 11, 2020
In this post, I will show you step by step in the easiest way possible how to mount a DigitalOcean Spaces Bucket. Afterwards, you can access…
Create DigitalOcean Spaces credentials
June 11, 2020
Generate Access Key and Secret Key for DigitalOcean Spaces. It is easy to create an access key and a secret key for your DigitalOcean…
Allow Remote MySQL Connections in cPanel
November 15, 2023
By default, cPanel does not allow remote MySQL connections, which is a good thing as long as you don't need to. If you are using cPanel and…
Allow Remote MySQL Connections in WHM
November 15, 2023
By default, remote connections to MySQL are disabled in WHM. If you would like to allow a remote IP to connect to your MySQL instance, let's…
Restore a Linux File Backup
June 10, 2020
This tutorial explains how you can restore a linux file backup of, for example the /var/www directory on your server. Step 1 Assuming you…
DigitalOcean Supported Regions
June 10, 2020
Last Update: May 29, 2023 At the moment, DigitalOcean has 13 data centers across the globe: New York City , The US: NYC1, NYC2, NYC3 San…
The Ultimate MySQL Database Backup Script
January 17, 2024
This article and video are part of “The Ultimate Backup Script” serie we are creating to provide you with MySQL database backup scripts…