Searching Through a Database with PhpMyAdmin

Reading Time: 3 minutes

Using PhpMyAdmin to search for records and information in your database can quickly help you get the information you need without having to run advanced search queries. This tutorial assumes you have already logged in to PhpMyAdmin, and shows how to search by keyword and for a range of records.

Continue reading “Searching Through a Database with PhpMyAdmin”

Copying a Database Table with PhpMyAdmin

Reading Time: 2 minutes

Copying a table is quick and easy to do within PhpMyAdmin. Whether you are trying to make a backup copy before changes are made, archiving data, moving data to a new site or application, or even just working on restructuring your database, PhpMyAdmin can help you get the job done in just a few clicks.

This guide assumes that you have already logged in to PhpMyAdmin.We will go over how to copy a table and go over a few of the options PhpMyAdmin gives us.

Continue reading “Copying a Database Table with PhpMyAdmin”

How to Install mlocate on CentOS 6

Reading Time: < 1 minuteOne of the best tools for quickly finding files by filename is the locate command. The locate command reads one or more databases prepared by updatedb and writes file names matching at least one of the patterns to standard output, one per line.
Pre-Flight Check
  • These instructions are intended specifically for installing mlocate on CentOS 6.
  • I’ll be working from a Liquid Web Self Managed CentOS 6 server, and I’ll be logged in as root.
Continue reading “How to Install mlocate on CentOS 6”

New User Tutorial: Basic Shell Commands

Reading Time: 3 minutesNow that you know how to SSH into your server it is important to familiarize yourself with some basic command line tools. Continue reading “New User Tutorial: Basic Shell Commands”

How to Use the Find Command in Linux

Reading Time: 2 minutesThe find command is a wonderfully useful tool that allows you to find files or folders by searching for them in multiple ways. Continue reading “How to Use the Find Command in Linux”