How to use MySQL stored procedures and routines?

How to use MySQL stored procedures and routines?

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
How to change the MySQL timezone

How to change the MySQL timezone

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
How to change the database engine of a MySQL database table?

How to change the database engine of a MySQL database table?

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
jHackGuard Support Page

jHackGuard Support Page

jHackGuard is a security solution for Joomla developed by XonHost It protects your website by filtering the data from the users’ input and implements additional PHP security settings. At the same time the plugin is disabled for the authenticated administrators so … Continued