Importing a large database

[Nathan Malcolm]

I wouldn't even consider 1 GB large. That's a pretty small amount to handle to be honest.

OP, if you don't have shell access I advise you use MySQLDumper (But make sure you block off public access. It can do more damage than good if in the wrong hands).

[Salih I]

This user has been denied support.

I wouldn't even consider 1 GB large. That's a pretty small amount to handle to be honest.

+1

[weBex]

Most hosts are just stingy with the SQL import limit, the highest I've seen was just 50mb.

[Tom K.]

@TOM: i used ">" which means greater than not less than. Ohhh GOD is there no programmers here. They would definitely understand me

No, your logic is flawed.

This: "Large DB >= 1gb" would be fine. "A large database is greater than or equal to 1gb". If you wrote a program with your logic you would get the wrong results, you said anything equal to or less than 1gb is a large database.

---

Let me put it this way for you:

a = a house
b = a car

Now, usually, a >= b yes? Because, in terms of size a house is greater than or equal in to that of a car. Ok, so on a scale of size, it looks like this

---b-----------------a---

Where a house is further up the scale of size than a car correct? Now, replace the car with "1gb" (the thing you are comparing a database's size to) and a house with the "large db". See where your logic fails?

---

Also, regarding less than and greater than. You must flip the sign if you swap the sides. EG:

x >= y
y <= x (sometimes written "y =< x" which is easier to see the flip )

So, "1gb is greater than of equal to a large database" is the same as " a large database is less than or equal to 1gb" - they mean the same.

We do it all the time when comparing things. A house is bigger than a car, and a car is smaller than a house.

---

Also, as a side note, I am a programmer, of multiple languages. Many members here are.