MySQL Databases

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