In this guide, we’ll show you how to make changes to your database settings in the MySQL my.cnf file. For example, you may need to increase the number of max_connections or the query_cache_size value for your server. To do this, you simply log in the server via SSH and edit the my.cnf file using an editor such as Nano. This article Read More >
Search Results for: phpmyadmin
The Complete Guide to cPanel Backups
cPanel comes with an extensive suite of built-in backup tools. Below, we cover how to use these cPanel Backup utilities to both backup and restore files on your cPanel account. InMotion Hosting also offers Backup Manager to keep your account backed up and secure. Get the best in cPanel backup tools at an affordable price Read More >
MariaDB: Adding and Removing Indexes
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 >
The Value of Different Types of Backups
Should you use WordPress backups, a database backup, or something more comprehensive like Backup Manager or WHM scheduled cPanel backups? The answer is yes! Different backup solutions solve different problems. Some backups are quicker to restore, while others are more comprehensive. If you ever find yourself facing a crisis, more backups will mean more options. Read More >
How to Work with Feature Lists in WHM
When you create new packages for your cPanel accounts within WHM, you assign a feature list to that specific page. A Feature list is exactly what it sounds like; a list of features that each cPanel account has. This article pertains to WHM, a feature only available to VPS Hosting, Dedicated Hosting, and Reseller Hosting Read More >
Export Your Database With WP Migrate
In this article we will outline how you can export your database using the WP Migrate (formerly known as WP Migrate DB) plugin. This free WordPress plugin allows you to export data from your WordPress dashboard, saving you the time and hassle of logging into the phpMyAdmin database manager. This is particularly useful for migrating Read More >
Why cPanel — What Features are in cPanel?
Why cPanel? cPanel is a web hosting control panel designed for ease of use. It is the most popular tool of its type in the world and included on many of InMotion Hosting’s plans. cPanel allows you to use various tools by way of a Graphical User Interface (GUI). This makes account management much easier Read More >
How to Export Your WordPress Sites
Exporting your WordPress site can be used for site moves or simple backups. In this guide, I’ll provide some simple and easy options to export your WordPress sites for both non-technical and technical people. Exporting your site creates a backup of your site, usually in the form of a .tar.gz or .zip file, which you 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 >
Can I do a Search & Replace in the WordPress Dashboard?
This article explains the benefits of performing a search & replace from the WordPress Dashboard. Then, we go over the most popular plugins for performing a database search & replace. Ways to Search & Replace Why Search & Replace from the Dashboard? Search & Replace Plugins Ways to Do a Search & Replace Just as Read More >
How to Fix the Repeating Installation Screen When Migrating your WordPress Site
Checking your Database Credentials Checking your WordPress Database Table Prefix A common problem you may come across when moving your WordPress site from one host to another is the issue of the repeating WordPress installation screen. This happens after you’ve done all the hard work for the migration and you put your domain name into Read More >
How to Resolve Site Health Performance Issues
With the WordPress 5.2 release comes the new Site Health feature to help website owners improve performance in any WordPress website Below we cover how to resolve Site Health performance issues. Psst! Get quality speed and security for cheap with our Nginx-powered WordPress Hosting. Performance Checks Performance tests check that background tasks are stable and Read More >
cPanel Tasks To Enhance Website Creator
Web design includes many aspects that require constant learning – user experience, analytics, marketing, etc.. But there are some important cPanel tasks you should understand to make the most out of your website. Listed below are cPanel features to help you maximize your website and online brand. Note that cPanel creation is no longer unlimited. 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 >
Create a Database Diagram in MySQL Workbench
It is helpful to have a visual representation when designing a database. MySQL Workbench allows you to create entity relationship diagrams (ERDs) with relationships between the tables (one to one, one to many) and rearrange them as needed. Below we cover how to create an ERD from a downloaded SQL file. Create a Diagram from Read More >
How to Create a MySQL Database Using the cPanel API
If you are running cPanel on your server, then you should use the cPanel API to create the database from the command line. Creating the database this way, allows for cPanel to integrate the necessary permissions for each cPanel user to access the databases they are granted access to. For instance, if you create a Read More >
How to Login to your Website Creator Account
Welcome to your Website Creator account! We know it can be frustrating to have multiple logins to different web accounts. This is why we’ve installed a single sign-on that lets you log into your Website Creator right through your InMotion Hosting Account Management Panel (AMP). In this article, we’ll cover a few different ways of Read More >
How to Fix “Too many Redirects” Error in WordPress
If your WordPress site is not loading, and you see an error stating that your domain has “Redirected you too many times” or is trying to complete “Too Many Redirects”, you are caught in a redirect loop. Below, we’re going to talk about how this might have happened and ways to fix it. HTTPS Redirection Read More >
How to Create a Local Dev Server with Vagrant
Now you can start developing like a pro with your own local hosting environment. You may have heard about how you can develop sites locally with your own Apache, MySQL and PHP server. It’s never been easier to install this software and have it running on your computer in a matter of seconds. In this Read More >
What is SQL?
In this series, we are going to going through some of the basics of using SQL. No prior experience with SQL is required. This will not be an extensive course. The history of SQL is outside of the scope of this series. However, we will touch briefly upon how SQL is used and for what Read More >
