Old PHP could leave your website exposed to possible security attacks. And you could be missing out on features like improved security and performance. We recommend that you stay up to date with the latest PHP so that your website runs smoothly and is ready for future website development. That […]
vBulletin Fix
vBulletin has persistent connections turned on at all times. On our shared hosting, the forums may get very slow because of the 25 MySQL connection limit. This can even cause vBulletin to spit out errors like Too many MySQL connections. There’s only one real way to fix this on shared servers […]
MySQL Collation
Changing the Default Collation for a Database To change the collation for a database, follow the instructions below: Log in to cPanel In the Databases section, click phpMyAdmin. In the left pane, select the database you wish to manage from the dropdown menu. On the top menu bar, click on the Operations tab. At the bottom […]
MySQL Stored Procedures, triggers
Please note that this function is an aspect of web design/coding. Therefore, you must supply the working MySQL statements. Support from HostGator is limited to ensuring MySQL works and the stored procedures exist. Shared and Reseller We currently allow you to create, execute, alter, and view stored procedures on your […]
mod_deflate
In Linux systems, mod_deflate is used to compress HTTP content before it is served to the client; this results in faster network transfers. Compressing Content Apache 2.0, 2.2, and 2.4 allow you to compress content using mod_deflate before sending it to the visitor’s browser. The types of content to be […]
.htaccess Guidance
The .htaccess file is a special Apache file that adjusts the way your website behaves. You can edit the existing .htaccess file on your site, or you can create a new text file in any directory and name it .htaccess. How can I secure my .htaccess file? The .htaccess file […]
Exporting a MySQL Database via phpMyAdmin
Finding phpMyAdmin in your Control Panel Once a database is created, you can access it via the web administration panel. cPanel Log in to cPanel. Look for the Databases section, then click the phpMyAdmin icon. A list of available databases will be displayed once you expand the username on the top left-hand side of the phpMyAdmin homepage. […]
Managing Your Database With Applications
There are many applications that can be installed on your computer for managing your databases. Here are some suggested applications you may use for that purpose. Third parties supply these applications – some are free, and some may require you to purchase a license. The database management program (application) you choose […]
Using Databases Overview
Many websites use databases and scripting languages such as PHP, ASP, and ASP.NET to create dynamic sites and manage large amounts of information, rather than using only static HTML files. Two of the most popular databases are MySQL and MS SQL. Whether you are creating a website from scratch by […]
How to fix the “Missing MySQL Extension” error
Note: This workaround will work if you previously used the PHP Selector to manage the PHP version for your site, then recently used the new MultiPHP Manager to update your PHP version. In the video below, we will walk you through identifying the “Missing MySQL Extension” error and the steps to resolve it. You […]