MySQL Databases

A database index is a data structure that improves the speed of operations in a table. Every time your web application runs a database query, the database will look through all the rows in your table to find those that … Continued

You can empty the content of a MySQL database via phpMyAdmin or SSH. We would highly recommend you to create a backup of your database (phpMyAdmin or SSH) prior making any changes to your databases. Using phpMyAdmin This is by far the easiest way to … Continued

MySQL database size limitations are applied for all shared hosting plans, in order to ensure fair resource usage. The limitations are as follows: StartUp – 500 MB GrowBig – 750 MB GoGeek – 1000 MB If a database on your … Continued

Your user does not have enough privileges for creating or dropping databases in phpMyAdmin because of security restrictions. The only way you can add or drop databases is through cPanel’s MySQL manager.

If you want to connect to your database from an application or a script on your XonHost hosting account, you can simply use localhost as MySQL hostname. If you’re accessing your database from a remote server, you need to grant it access … Continued

The phpMyAdmin tool can be used to import MySQL databases up to ~50MB. Files above that would cause the service to time out and the import will fail. If you need to import larger databases on your account, you can do that … Continued

There are two ways of exporting a MySQL database from your account: You can export it via the cPanel -> phpMyAdmin tool. You can find information how to do that in our tutorial here. You can perform the export by accessing your account via SSH. Our article explains … Continued

XonHost supports MySQL and PostgreSQL databases. With our standard hosting package you can have UNLIMITED MySQL and Postgres databases. You can manage your databases with a few mouse clicks through a web-based control panel (cPanel). For more information check our MySQL … Continued

The easiest way to change the password for your MySQL user is to: Log in your cPanel -> MySQL Databases. Find the corresponding database and see which is the user attached to it. For example we will consider that your database is called yourusername_database and … Continued

In order to solve this issue follow these steps: Open the MySQL backup with a text editor on your local computer. Delete the line saying “CREATE DATABASE yourdbname“. Usually this line is found at the very beginning of the file. … Continued