What MySQL storage engines are supported on your servers?

Our servers support InnoDB and myisam MySQL storage engines.

Do you support foreign keys in phpmyadmin?

Foreign keys are supported on all of our packages!

#1064 You have an error in your SQL syntax

The error 1064 occurs due to MySQL version mismatch. Different versions have different reserved words, which, if they are used by a previous version, causes the error to occur.

Do you support foreign keys in phpmyadmin?

Foreign keys are supported on all of our packages!

How can I modify database charset?

You can modify database charset using phpmyadmin at any time. Simply select the database you want to edit, click 'Operations' tab and look for 'Collation' field. Select new charset and click 'Go' button to save your changes. If you need to modify charset for an individual table or even field, you can repeat the same operation after selecting the desired ...

How many mysql user connections do you allow (at the same time)?

Our servers are set to use up to 15 simultaneous MySQL connections for one MySQL user at the same time.

How to import/export database?

To import/export a MySQL database you need to follow these simple steps: - If you want to import database please log in to Control Panel, find MySQL Databases and create a new database. - Login to phpMyAdmin and click Import / Export button at the top of the page. This section will allow you to import or export any database!&...

Is event_scheduler enabled for MySQL?

event_scheduler is currently disabled on our Shared Hosting packages. However, it can be enabled on a VPS, so feel free to check out the available VPS packages: https://ultahost.com/service-vps

is mysqli enabled?

Yes! The mysqli module is enabled and is fully supported by default on our servers and since MySQL is officially deprecated in PHP v5.5.0 and removed in PHP v7 you can use mysqli module from PHP version 5.0.

MySQL timeout errors

If you experience MySQL timeouts, it's possible you are using heavy or very long MySQL queries. Please try using mysql_reconnect command before each query, and everything should be fine.

What formats of database uploads are supported?

You can upload your database in the following formats using phpMyadmin: CSV DocSQL Open Document Spreadsheet Esri Shape File SQL XML

What kind of SQL is being used for Ultahost's servers?

We use MariaDB on our Shared Hosting packages. MariaDB is an enhanced replacement for MySQL. The main reasons why we chose MariaDB instead of MySQL are that MariaDB has more improved query optimizer, updates are released regularly, and the overall performance of MariaDB is better. You can check the current version of MariaDB used on our server in your hosting ...