If your WordPress database has grown unusually large (for example, from 1GB to 6GB), it usually means your website is storing unnecessary data such as logs, transients, revisions, or WooCommerce activity records. This guide will help you safely reduce your database size without breaking your website. ⚙️ Step 1: Check Which Tables Are Large Log […]
If you’re an Intek Host user looking to manage your databases with advanced tools like MySQL Workbench, this article will guide you through the process of connecting to our database using Remote MySQL Access. While the integrated phpMyAdmin tool is available, using remote SQL can provide you with additional features and robustness for efficient database […]
Reducing the size of your WordPress database can significantly improve your website’s performance and loading speeds. Here are practical steps to help you efficiently manage and minimize your WordPress database size: Step 1: Back Up Your Database Before making any changes to your database, ensure you have a complete backup. This protects your data should […]
Every database or site administrator needs to do database maintenance regularly. The ability to retrieve queries much more quickly is what makes a responsive website different from one that seems slow; this is all thanks to an efficient and well-managed database. Magento Sometimes, there’s no clear cause for why Magento databases can grow in size! […]
The most typical cause of the MySQL server has gone away problem is because the query timed out and the connection was ended. This can occur when a MySQL query times out (i.e. is too sluggish). To attempt and help with this error, we propose conducting a MySQL check/optimization through phpMyAdmin, as follows: 1. Sign […]
Here at Intek Host, each MySQL database you create can store up to 1024 MB (1 GB) of data. As databases comprise of only text, this is a lot of space in real terms; to put it into perspective, a client at Intek Host’s average database size is just 10 MB. In the rare event that you […]
MariaDB is a fork of MySQL. The database structure and indexes of MariaDB are the same as MySQL. This makes MariaDB a backward compatible, drop-in replacement for MySQL. We currently run MariaDB version 10.2.29 To check the version of MariaDB: Head to Manage Hosting, then phpMyAdmin. Select the database in the left-hand panel. Select the Query tab at the top. […]
When you lose your login details, you can manually go through your StackPanel database and set a new username and password. This guide below will help you accomplish this: 1. Open your Intek Host StackPanel and single-click on your File Manager (which is usually located on the Web Files tab). 2. Next open the public_html folder (or the […]
You can use phpMyAdmin to import an .SQL file with your database information. To do this: ● Log in to your database via phpMyAdmin (https://cp.intekhost.net > Manage Hosting > [select package] > phpMyAdmin) ● Choose the database you want to import your .SQL file to from the left hand side. ● Click the Import tab at the top of the page. ● Select Choose File and […]
You can create MySQL databases in seconds directly from your Intek Host control panel. This option is unavailable for packages hosted on our WordPress platform due to its WP-optimized nature. If you need to create a MySQL database, you’ll need to move the website to our Linux platform. To create new MySQL databases: 1. Log […]