Searching Through a Database with phpMyAdmin

This tutorial assumes you’ve already logged in to phpMyAdmin.  Now let’s learn how to use the Search feature.

  1. Click the database you wish to search here.phpma-search-frame03_1
  2. Then click the Search tab and enter words or values to search for in the database.
    phpma-search-frame04_1
  3. There are several options you can use to refine your search. This database only has one table (details), but if there were more, you could limit your search to specific tables here.phpma-search-frame05_1
  4. When ready, click Go to perform the search. This search found one match. Click Browse.phpma-search-frame06_1
  5. We can now make changes to the record that was found.phpma-search-frame10_1
  6. Click Go when finished.

 

How to Install mlocate (locate and updatedb Commands) on CentOS 6

One 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 (locate and updatedb Commands) on CentOS 6”