Thread: MYSQL Upload
View Single Post
Old 10-09-2007, 10:04 AM   #2 (permalink)
admin
Administrator
 
Join Date: Aug 2007
Posts: 52
Default

Hi Cavillas,

There are several ways you can do this, below are the most common ones. First of all you will need to export your current database into a format that can be re-inserted on our servers. Do you have phpmyadmin on your computer? If so you can export from that.

1) Every package comes with phpmyadmin which is a visual, web based admin tool for mysql databases. This comes with its own import facility, it accepts raw sql, csv and even gzipped sql file formats.

The only problem with his method is its not very reliable for databases of a big size (I think the maximum you can import is 2mb via this method).

2) Use a script, for example "big dump" -BigDump: The Staggered MySQL Dump Importer

This is a very useful tool for importing big database dumps, it basically takes an sql file (you can use zipped files as well) and periodically reinserts into a database a few 1000 records at a time. Its very reliable and would be my reccomendation if you didn't have shell access or not sure of how to insert mysql dumps on the command line.

3) Mysql command line, you will have shell access with all our accounts (on request, its not enabled by default) which will allow you to insert mysql dumps straight from the command line, if you know how to do it this is by far the most reliable and quickest method.

Hope this has helped and let me know if you have anymore questions. You can post them here or ask at the sales@dream-hosting.co.uk address.
Admin - Nick
admin is offline   Reply With Quote