How to setup slow query logging in MySQL
This guide will explain how to set up “slow query” logging in MySQL so that you can determine which queries are causing slowdowns. …
This guide will explain how to set up “slow query” logging in MySQL so that you can determine which queries are causing slowdowns. …
This short guide will explain how to use a free command line utility to monitor a MySQL database in real-time. …
This guide will show you one of the easiest methods to securely access a remote MySQL database. …
How to Remotely Access your MySQL in a Secure MannerRead More »
This short but detailed guide will explain how to reset your lost or forgotten MySQL root password using either Windows or Linux. …
This tutorial will show you step by step how to install and setup WAMP (Windows, Apache, MySQL & PHP). …
How to install and setup Apache, MySQL and PHP in Windows (WAMP)Read More »
This guide will show you how to quickly and easily install MAMP, so you can use Apache (and Nginx), PHP and MySQL on your Mac. …
How to Install Apache, MySQL and PHP (MAMP) in macOSRead More »
awk, sed, and grep are three of my favorite tools in the Linux or UNIX command line. They are all pretty powerful. Today we’ll look at how to get cracking with awk to help you ease into using it. Then we’ll look at some useful awk one liners to make things a bit more fun for you. …
This guide will explain how to get a list of open files, sockets and pipes in Linux using the lsof command. …
How to get a list of open files, sockets, and pipes in LinuxRead More »
This guide will explain how to use RPM (the Redhat Package Manager) to install and manage software in Linux. …
How to Install and Manage Packages in Linux with RPMRead More »
The other day I needed to migrate a directory containing a lot of files from one location on my Linux server to another. There are a number of ways I could do this. Using a simple cp command could have done the trick. However, as the data I was copying was a database and I wanted to make sure that the copying was done perfectly, I looked on the Internet and found a brilliant one line bash solution for this. …
How to Compress, Move, and Extract a Directory in LinuxRead More »
This guide will explain how to use the command netstat to monitor your Internet and network connections in Linux. …
This guide will show you how to use the command ‘nohup’ to run processes in the background, so that they keep running even if you log out or get disconnected. …
How to Run Processes in the Background Using nohup in LinuxRead More »
This guide will take you step by step through the process of creating automated backups in Linux (and most *nix Operating Systems). …
After writing more than a dozen of these tutorials and installing and removing so many different applications, I thought to myself, there has got to be a faster way. WiFi is far faster than Bluetooth and far more convenient than digging for a USB data cable. I have a computer running Linux, I have a wireless network, and the N95 connects via WiFi so why not just run Apache on my computer and point the N95 at a directory on the computer? …
How to install applications on your N95 from a local web serverRead More »