Using PhpMyAdmin to export a database or table is a great way to make a backup you can save locally, or it can help you with transferring that information to another server quickly. A few simple steps can be a powerful tool to help you and your business. We will go over exporting all databases at once, a single database, and exporting a single table. This guide assumes that you have already logged in to PhpMyAdmin.Continue reading “Exporting Databases and Tables with PhpMyAdmin”
Reading Time: < 1 minute
MySQL via Command Line 101: Basic Database Interaction
- These instructions are intended for creating a MySQL user on Linux via the command line.
- I’ll be working from a Liquid Web Core Managed CentOS 6.5 server, and I’ll be logged in as root.
Using PhpMyAdmin to import databases can help us in a few different situations, like when moving a database from one server to another, updating a table that is being developed elsewhere, or even restoring content from a backup. PhpMyAdmin helps make all those processes easy to accomplish through our browser.
This guide assumes that you have already logged in to PhpMyAdmin. We will go over what happens if we try to import into an existing database, importing a single table, and also partially restoring from a full database backup.Continue reading “Importing Databases and Tables with PhpMyAdmin”
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”
In this tutorial, we will explore how to run SQL queries on a database within PhpMyAdmin. SQL stands for Structured Query Language. SQL statements or queries are used to perform database tasks such as searching, updating, or retrieving data from a database.Continue reading “Running SQL Queries on a Database with PhpMyAdmin”
Reading Time: 3 minutes
If you are looking to collaborate with your coworkers or employees and create and share documents on your Ubuntu server without taking up space on your local computer system, LibreOffice is the perfect tool for you. Formerly known as OpenOffice (based on StarOffice) this tool has evolved largely from the vast community of developers that contribute to its success daily. This powerful tool is currently in use by millions around the world as a free and open-source alternative to the Microsoft Office Suite of tools.
This tutorial assumes you’ve already logged in to PhpMyAdmin. Now let’s familiarize ourselves with databases and PhpMyAdmin.Continue reading “Becoming Familiar with Databases in PhpMyAdmin”
Reading Time: < 1 minutePostgreSQL supports many client authentication methods, but in this case we’re only going to concern ourselves with two: password and md5.
WordPress has a great GUI-based installation process however some use cases call for CLI! Or, maybe you just feel more at home in a terminal, either way this article will show you how to get your WordPress site setup with just a terminal, using WP-CLI, and maybe a sprinkle of SSH.
In order to be able to install WordPress manually using WP-CLI you will first need to create a new database for the WordPress install. You will need to know how to find your SSH credentials as well as being used to using Terminal or Putty and WP-CLI.Continue reading “Installing WordPress using WP-CLI”
PostgreSQL (pronounced “post-gress-Q-L”) is a household name for open source relational database management systems.
Its object-relational meaning that you’ll be able to use objects, classes in database schemas and the query language. In this tutorial, we will be demonstrating some essentials like creating, listing and deleting a database.