Portal Home > Knowledgebase > MySQL management issues
The knowledgebase is organized into different categories. Either choose a category from below or search the knowledgebase for the answer to your question.
Search
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...
Views: 11
How can I change my MySQL database collation?Usually you will be interested in changing your MySQL collation in order to solve problems with...
Views: 7
How can I empty a MySQL database?The easiest way to empty a MySQL database is through phpMyAdmin. Once in phpMyAdmin,...
Views: 6
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...
Views: 14
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...
Views: 10
How to optimize a MySQL databaseOne of the most important prerequisites for achieving optimal MySQL database performance is...
Views: 8
How to optimize a MySQL database using phpMyAdmin?It is always a good idea to keep your databases' tables optimized. Fortunately, making this...
Views: 12
How to repair a MySQL database?In this article we will show you two ways to repair a MySQL database. 1) Through...
Views: 9
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...
Views: 17
I have problems accessing my MySQL database remotelyIf you have problems accessing your database at your web hosting account remotely please make...
Views: 26
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...
Views: 11
Is SQLite supported?SQLite is a software library which implements an SQL database engine. SQLite and PDO_SQLite are...
Views: 10
What is the information_schema database?In MySQL version 5.02 and above there is an additional database called information_schema. This...
Views: 10
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...
Views: 7
Quick Navigation
Search

















