Articles
The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a...
How can I change my MySQL database collation?Usually you will be interested in changing your MySQL collation in order to solve problems with...
How can I empty a MySQL database?The easiest way to empty a MySQL database is through phpMyAdmin. Once in phpMyAdmin,...
How to change the MySQL timezoneWhen you develop your website, you may have to compare a certain date/time with the current...
How to change the database engine of a MySQL database table?In this article we will show you how to change the database engine of a MySQL table. Let's...
How to change the password of a Mysql user in cPanel?If you have already created a MySQL user through the cPanel -> Mysql Databases tool you may...
How to export a large database using phpMyAdmin?If you have a large database, it may be difficult to export all of its tables at once through...
How to export/import a MySQL database via SSHIn this article we will show you how to export and import a MySQL database via SSH. Managing your...
How to optimize a MySQL databaseOne of the most important prerequisites for achieving optimal MySQL database performance is...
How to optimize a MySQL database using phpMyAdmin?It is always a good idea to keep your databases' tables optimized. Fortunately, making this...
How to repair a MySQL database?In this article we will show you two ways to repair a MySQL database. 1) Through...
How to reset the password for a MySQL database?You may need to change the password of your database in order to improve the security of your...
I get an error 'ACCESS DENIED CREATE DATABASE db_name' when I try to import a databaseIn order to solve this issue follow these steps: Open the MySQL dump with a text editor on...
I have problems accessing my MySQL database remotelyIf you have problems accessing your database at your web hosting account remotely please make...
I'm getting a 'MySQL server has gone away' error in my applicationThere are two main reasons for this error message to show: 1) The MySQL query you are...
Is SQLite supported?SQLite is a software library which implements an SQL database engine. SQLite and PDO_SQLite are...
What is the information_schema database?In MySQL version 5.02 and above there is an additional database called information_schema. This...
What type of databases do you support? PGSQL and MySQL?All our servers support MySQL and PostgreSQL databases. Also with any of our hosting packages...
