	Home Web Hosting domains Domains

Customer Support

Support Categories:

Getting Started
FTP
Moving Domains
E-mail
Stat Reports
Mailing Lists
Apache
PHP
CGI
MySQL Database
Other Software
Billing & Terms
Control Panel
E-commerce
Pre-Sales

Search for keywords:

Browse by category:

Do you offer MySQL 5?

Yes, we do. Our newest database server "db1.modwest.com" now offers MySQL 5 for our new and current users.

If you want to create a new MySQL 5 database:

First you must go to OnSite and log in as the administrator.

Once you are there, click on the "Add or Drop Database" link under the "Database" heading.

You will now be presented with the "Create New Database" screen. Under the drop-down menu labeled "Database server" select db1.modwest.com.

Now, enter the name of the new database that you want and click on "Create Database." Upon success, you should receive confirmation that the database has been created.

If you want to migrate your existing database to MySQL 5:

NOTE: There have been many changes from MySQL 4 to MySQL 5, it is your responsibility to ensure that your database is compatible with MySQL 5 before migrating.

For more information about the changes between version 4 and 5, please check out the MySQL documentation. Also, be sure to check out the updated list of 'reserved words' that can cause issues.

In order to migrate your existing database to the new server, you must first 'Add a New Database,' following the instructions above. From there, you need to dump your existing database and import it into your newly created database.

For instructions on how to move your database from one server to another, you can follow our FAQ here.

User-Contributed Notes
There are no user-contributed notes for this topic.

Related Questions:

How do I import delimited data into MySQL?

How do I change my MySQL password?

How do I import a MySQL dumpfile into my database?

How can I export data in CSV or tab delimited format?

How do I connect to my MySQL database?

Why do i get a query syntax error 1064 from MySQL when the syntax seems correct?

How do I export and move my database tables between servers or copy databases?

I can't connect to local MySQL server through socket 'mysql.sock'

How do I create a .my.cnf MySQL preference file?

What is my database server name?

How do I change MySQL timezone?

What is my MySQL Username or Database Name?

MySQL says I have too many connections.

How do I check how much disk space my database is using?

A MySQL MYI table has errors in it.

Can I connect to MySQL remotely?

Can I connect to my MySQL database from my own computer?

I can't get phpMyAdmin to work.

phpMyAdmin gives SQL syntax error when I try to create table.

How can I use odbc_connect() in my PHP scripts to connect to MySQL?

What kind of database server do you offer?

How many databases do I get?

What am I allowed to do with my MySQL database?

Will we be able to do our own MySQL admin?

How do I import a MySQL dumpfile into my database via phpMyAdmin?

How do I export a MySQL dumpfile via phpMyAdmin?

Browse Categories: