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 >

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 >

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 >

Create a Database Diagram in phpMyAdmin

To produce an entity-relation diagram (ERD) for a database on your server, you don’t have to download MySQL Workbench or login remotely. Below we show you how to create and export an ERD in cPanel phpMyAdmin, create relationships between the tables – i.e. one to one, one to many – and rearrange them as needed. Read More >

Create a Database Diagram in MySQL Workbench

It’s helpful to have a visual representation when designing a database. MySQL Workbench allows you to create entity-relation diagrams (ERD’s) and create relationships between the tables – i.e. one to one, one to many – and rearrange them as needed. Below we cover how to create a diagram from a downloaded SQL file. You can Read More >