N3RVE

N3RVE

Dispatches On Everything Tech!


Navigation
Featured

General

Safely Restart a MySQL Slave Server

Posted on June 7th, 2016.

Ensure it’s not accessible by any clients, if you use a load balancer, you should take it off temporarily. Connect to the MySQL Server via the command line: Stop the replication: Now is a good time to make any changes you want to. Resume replication: Check the status to confirm replication is running normally, and […]

Featured

General

Painlessly Transfer a Heroku Postgresql DB to a Virtual Private Server (VPS)

Posted on June 2nd, 2016.

After spending hours researching a method to easily transfer (backup / restore) a heroku postgresql database to a VPS, I finally found a quick way to do it that didn’t involve tons of errors about version mismatches, incomplete restores (using psql), and etcetera. I’m documenting this here in case I need to refer to it, […]

Featured

General

How To: Install “Log.io” on Ubuntu 14.04

Posted on November 6th, 2015.

This tutorial presents the steps to install and monitor local log files in real time from a browser using Log.io – For information on Log.io and how it works, see its home page: https://logio.org/

Featured

General

Getting a Static IP Address in Nigeria

Posted on October 27th, 2015.

Chances are you’re reading this because you’re interested in obtaining a static IP address from a Nigerian based Internet Service Provider (ISP). Continue reading if you’re interested in the requirements as well as the uses and advantages.

Featured

General

How To: Enable Remote MySQL Connections on Ubuntu Server

Posted on August 31st, 2015.

1. Identify public IP address: 2. Edit /etc/mysql/my.cnf, replacing the value for bind-address, usually 127.0.0.1 with your public IP address derived above: 3. Type the following to enter the MySQL shell and provide your password: 4. Grant remote access to the desired MySQL user with the following command, replacing ‘root’ with the desired user and […]