Articles

 Can I change the name of a MySQL database?

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, select the...

 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 MySQL timezone

When you develop your website, you may have to compare a certain date/time with the current...

 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 SSH

In this article we will show you how to export and import a MySQL database via SSH. Managing your...

 How to optimize a MySQL database

One 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 cPanel:...

 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 database

In order to solve this issue follow these steps: Open the MySQL dump with a text editor on...

 I have problems accessing my MySQL database remotely

If 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 application

There are two main reasons for this error message to show:   1) The MySQL query you are trying...

 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...