Database tables often need altering during their life cycle. As your needs change, the data you store will often need to change to reflect these needs. Perhaps you recently added a column to your database, or you find out that certain columns are getting searched. In this article, we will explore how to add and Read More >
Working with Databases
Most websites these days are driven by a database, which stores and organizes information in a different coding language – e.g. MySQL, MariaDB, PostreSQL. Get started with our guides below covering database management with cPanel, phpMyAdmin, SSH, and more.
Creating, Importing, Exporting:
Learn how to create, import, and export databases in this section.
Connecting:
This section includes popular articles regarding making a database connection.
Troubleshooting Errors:
This section covers some of the common errors you may experience regarding databases.
Working with phpMyAdmin:
This section includes walk-through guides for the phpMyAdmin tool, which is available in the cPanel, and lets you administer your MySQL Databases.
Working with MariaDB:
This section includes walk-through guides for the use of MariaDB.
Working with Percona DB Server:
This section provides information on working with Percona DB.
General:
General database articles are included within this section.
- How to reset your database password within cPanel
- How to Check and Repair a Database
- How to Convert a Database to UTF-8
- How to convert MySQL time
- How to change MySQL server time zone
- MySQL Storage Engines – InnoDB and MyISAM
- Learning the different data types in MySQL
- How to determine your MySQL version number
How to Install MongoDB
While there are several different types of database software available, MongoDB is a popular and feature-rich alternative to other software such as MySQL. As this software is not frequently pre-installed on Linux-based hosts, you may find yourself needing to install MongoDB on your CentOS or Ubuntu server. In this guide, we will outline how to Read More >
How To Deactivate Plugins From The WordPress Database
What if a plugin takes down your site? Try to log in and disable it. What if you can’t log in because the whole site is down? In this article, learn how to deactivate plugins from the database using phpMyAdmin or your favorite database editor. Why You Should Go Through The Database Where Can You Read More >
How to Drop Tables and Columns with SQL
In the last article, we learned how to create a table for our database. We were working with a table of newsletter correspondents. Now, we are going to learn how to drop a table from our database. You may recall our goal in learning the basics of SQL was to be able to create, read, Read More >
342: Finding your WordPress database name
When using the Softaculous tool to install your WordPress, a database name is created for you by default. Many people do not even notice this setting since it is already entered and therefore do not remember the database name. You may, however, need to recall this name later on, especially when troubleshooting or when you Read More >
Create a Database with MariaDB
In this article, we’re going to show you how you can create a new database with MariaDB. This is going to be the same process as creating a MySQL database. However, using MariaDB in replacement of MySQL as your storage is reported to be faster and more efficient for inserting and selecting data. If you Read More >
How to Delete a Database with MariaDB
In this article, we are going to be deleted the databases with MariaDB. If you were curious about creating databases, you will want to check out the article on how to create databases with MariaDB. Using MariaDB inside your VPS/Dedicated server involved replacing MySQL as your database storage engine. How to Delete a MariaDB Database Read More >
Backup Your OpenCart Database in Admin Dashboard
Like using a SSL certificate, backups are important to your OpenCart and web hosting security. Below we cover how to backup your OpenCart database in your admin dashboard. Backup Database Login OpenCart. Under Settings, select Maintenance and Backup / Restore. Specify tables to backup and select Export. You can restore the .sql file in the Read More >
Check and Repair Database with WP-CLI
When a WordPress website shows an Error establishing a database connection, those with access to cPanel can check and repair databases using MySQL Database or phpMyAdmin. Below, we cover how web developers can check and repair a WordPress database using WP-CLI. Note: You must navigate to the root folder of your WordPress installation in SSH Read More >
How to Restore a Database With Backup Manager
InMotion Hosting’s Backup Manager for automated backups has an option to restore databases separately from files and folders. This is similar to restoring backups with cPanel MySQL Databases Below we cover how to restore a backup with cPanel Backup Manager. Note: The Backup Manager is a different tool than cPanel Backup and Backup Wizard. Restore Read More >