MySQL Databases

MySQL stored procedures and stored routines are supported after MySQL 5. All XonHost clients can use MySQL stored procedures and routines on their web hosting accounts. To use stored procedures, you should first create a database and add a database user to it. Make sure that … Continued

If you have problems accessing your database at your web hosting account remotely please make sure that: You are using the correct MySQL hostname – it should be yourdomain.com or your server’s name; You are using the correct MySQL database / username … Continued

When you develop your website, you may have to compare a certain date/time with the current date/time on the server. The timezone on XonHost’s servers is CST, CEST or SGT, depending on the location you have chosen for your account … Continued

On XonHost’s servers you are not able to create a new database directly from phpMyAdmin. This can be done only through cPanel’s MySQL management tool. For more information check this tutorial. You can also watch cPanel’s video tutorial for additional information.

The easiest way to change the database engine of a MySQL database table is through phpMyAdmin available in cPanel. For example, if you have a database table called my_table using MyISAM engine and you wish to change the engine from MyISAM to InnoDB you will need to: Access phpMyAdmin and select your … Continued

In this article we will show you two ways to repair a MySQL database. Through cPanel: Log in to your cPanel and go to MySQL Databases. In the section Modify Databases, select a database from the drop-down box next to Repair DB: and … Continued

It is always a good idea to keep your databases’ tables optimized. Fortunately, making this optimization is quite easy when using the phpMyAdmin tool available in cPanel. To perform the optimization, log in to your phpMyAdmin and select the database whose tables you … Continued

In MySQL version 5.02 and above there is an additional database called information_schema. This database is available inside the cPanel -> phpMyAdmin tool and provides access to the database metadata for the corresponding user. information_schema is the database where the information about all the … Continued

The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a “_” sign and the actual database name. For example, if your cPanel username is user and you create a database db, the database name will be user_db. … Continued

There are two main reasons for this error message to show: 1) The MySQL query you are trying to execute takes too long and the MySQL server times out. The solution for this issue is to optimize your database for … Continued