Probs at another host

[ctalksms]

I bought a package at another host (one of the pay-by-the-year hosts HostGator warns about) yesterday and had trouble importing an SQL database. After my sites were down all day and I had three companies working to try and help me get the SQL imported, the host informed me their SQL can't import a compressed file (such as gzipped).
Then they informed me they couldn't import the file anyway because their limit on SQL is 8.5 megs and mine is 24.5 megs. This was all after I had paid for the package. I checked HostGator's myPhpadmin and it is set up for over 50 megs. It pays to look at a host's capabilities before buying.

CTalksms

[Serra]

Yes, yes, YES... a lot of the time, people get hooked by the size and bandwidth, but never bother to look at the real important stuff, like limits for uploads, connections, cpu restrictions, open base dir, safe mode.... the list is endless.

[Eric]

Guess it's a good thing I chose HostGator. I wouldn't have known better when I first started out about all the limites, etc.

[Deb]

I own a web directory and my SQL files are HUGE, and the way I import them is as follows:

You can right click on the SQL file on your hard drive, and create a zip file. Then FTP the zip file up to your webspace.

Inside CPanel, you can click on the zip file and it'll present you with the option to extract it. Do this.

Then use PutTy to connect to SSH on your server.
Then cd to the folder your SQL file has been extracted into.

Type in the following SSH command to insert the SQL file into your db:

mysql -uuser_name -ppassword user_dbname < file.sql

Let's assume your username for your domain is:
mygoodsite

You then set up your db, and let's say it's name is web

So, now you have assigned a db user and password too, let's say it's dbuser: sam, and password: 12345.

Using these as the example, it's like this:

mysql -umygoodsite_sam -p12345 mygoodsite_web < file.sql
(replace file.sql with whatever the name of your REAL file is -- it can even be a .txt file too!)

The -u, and -p
are the flags that denote "user" and "password"
and these must be supplied prior to the user/pass in the format I've provided as an example.

hope this helps

[Serra]

Up until recently, ssh was unavailable to people here, so it isn't used or discussed much.

[Sergio]

Originally Posted by ctalksms

...Then they informed me they couldn't import the file anyway because their limit on SQL is 8.5 megs and mine is 24.5 megs. This was all after I had paid for the package. I checked HostGator's myPhpadmin and it is set up for over 50 megs. It pays to look at a host's capabilities before buying.

CTalksms

Actually, the limits is for one file only but you can circunvent this breaking your file in pieces and then importing all the files using phpMyAdmin one at a time.

Also, you will find that even that in HG you can upload a 50Megs file it will eventually not work becuase of the Load that the import of that size does to the server and it is likely that you will have to wait a long period in your browser and eventually find that the transfer didn't comes thru.

On the other hand if you have your own server, you can do as Deb saids, but if you don´t have SSH you will need to ask support to upload the file for you.