MYSQL Upload

cavillas · 10-09-2007, 09:51 AM

I have not signed up with you yet. I am thinking about it in the near future. The query I have is how do I upload a mysql database from my machine to your host? It's something I have never done before so need some guidance.

admin · 10-09-2007, 10:04 AM

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

cavillas · 10-09-2007, 01:58 PM

Many thanks for your reply. It all seems straightforward enough. Hope to be with you soon.

10-09-2007, 09:51 AM	#1 (permalink)
cavillas Junior Member Join Date: Oct 2007 Posts: 2	MYSQL Upload I have not signed up with you yet. I am thinking about it in the near future. The query I have is how do I upload a mysql database from my machine to your host? It's something I have never done before so need some guidance.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

10-09-2007, 10:04 AM	#2 (permalink)
admin Administrator Join Date: Aug 2007 Posts: 50	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

10-09-2007, 01:58 PM	#3 (permalink)
cavillas Junior Member Join Date: Oct 2007 Posts: 2	Many thanks for your reply. It all seems straightforward enough. Hope to be with you soon.