Frequently Asked Questions

MySQL Articles

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....

Importing SQL Files into MySQL Databases Using phpMyAdmin

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

Do you restrict any features in MySQL 4.1/5.0?

Yes. In order to protect our shared servers we restrict the following features:...

Using phpMyAdmin to Manage MySQL Databases

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

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...

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 limit MySQL database's size?

Yes, MySQL databases are limited to 1 GB each. The number of databases your site can...

Removing Databases from Your Hosting Account              

If you no longer need a database with your hosting account, you can delete it. To...

How do you limit MySQL databases?

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

Creating MySQL or SQL Server Databases for Your Hosting Account              

Windows hosting supports MySQL, MS SQL (SQL Server) and Access databases while Linux...

What are the major differences between MySQL 4.0 and 4.1/5.0?

For a complete list of the changes from MySQL 4.0 to version 4.1, see the Official...

What are the new features available in MySQL 4.1?

Some of the new features in MySql 4.1 32 bit password hashing This will offer...

Which MySQL features do you disable on hosting accounts?

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

Which version of MySQL should I choose?

Normally, if you are beginning to use MySQL for the first time, or have no other...

Moving Your MySQL Database from Hostway to Us

Having your domain registration and hosting in the same account can make running your...

What type of compression format should I use in PHPMyAdmin?

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

How can I back up my MySQL database?

The standard method for backing up a MySQL database is via the dump method. This...

Optimizing Your MYSQL Database

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

How many simultaneous connections can one MySQL database have?

We allow up to 200 simultaneous connections per MySQL user.

Managing Your Hosting Account's Databases

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

Are stored procedures supported in MySQL?

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

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'....

Connecting to a MySQL Database Using ASP/ADO

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

Exporting a MySQL Database from Your Hosting Account

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