Frequently Asked Questions

MySQL Articles

Managing Your Hosting Account's Databases

Using our hosting accounts, you can delete or edit databases you create. To Manage...

Accessing phpMyAdmin on Your Shared Hosting Account

phpMyAdmin lets you view and modify a database. You can change database values, run...

Connecting to a MySQL Database Using ASP/ADO

This example describes using ASP/ADO to connect to a MySQL Database. Replace values...

Connecting to a MySQL Database Using File DSN and ASP/ADO

This example describes using File DSN and ASP/ADO to connect to a MySQL Database....

Finding Your Database Admin URL

You can use the Admin URL in the Control Panel of your hosting account to directly...

Upgrading a MySQL or MSSQL Database

This article only applies to Web & Classic Hosting. For more information, see...

Delete Database

If you no longer need them, you can delete databases from your account. Before...

Export MySQL Databases

You have two options when exporting your MySQL database. You can either export the...

Import SQL Files into MySQL Databases

If you backed up or exported a database to a SQL file, you can import it into one of...

Optimize Table in MySQL

Optimizing your database removes the gaps in data or "overhead" that can occur when...

Restore MySQL Database from Another Host

You can restore MySQL databases you created at another hosting company. To do so, you...

Connecting to a MySQL Database Using ASP.NET

This example describes using ASP.NET/MySql.Data to connect to a MySQL Database. A few...

Do you restrict any features in MySQL 4.1/5.0?

Yes. To protect our shared servers we restrict the following features: MySQL 5.0 :...

How many simultaneous connections can one MySQL database have?

We allow up to 200 simultaneous connections per MySQL user.

How do I recompile the MySQL library to run under medium trust?

We have configured the .NET 2.0 environment to run in a customized medium trust...

How do you limit MySQL databases?

We allow up to 200 simultaneous connections per MySQL user. There is also a limit...

Which MySQL features do you disable on hosting accounts?

Some MySQL database features are not enabled on our shared hosting servers. Below is a...

Importing MySQL Databases via SSH

Servers without a control panel (such as cPanel, Plesk, or Simple Control Panel) do...

What type of compression format should I use in PHPMyAdmin?

When exporting your database from PHPMyAdmin, you can choose to either compress your...

Why do I get a MySQL "error: 1016 Can't open file: ..."?

Errors such as: ..."Got error: 1016: Can't open file: 'YOUR_TABLE_NAME.MYI'....

What is MySQL?

MySQL is a sophisticated and powerful relational database used by many websites to...

My Website Went down When MySQL Upgraded from 4.0 to 5.5

If your website was impacted by upgrading MySQL 4.0 to MySQL 5.5, we have some...

Are stored procedures supported in MySQL?

Stored procedures are supported in MySQL 5.0. A stored procedure is a set of SQL...

Create MySQL or MS SQL Databases

You can create databases on your hosting account for your websites to use. The types...