timjpriebe — Wed, 14 Jun 2006 13:03:04 +0000

There's multiple reasons, but that's not really one that I was thinking of. The SQL statements themselves my be more room than is taken up by the DB's info. Granted, the more I think about that, the less likely I think it is, but it is possible.

But to understand what I was talking about, consider this. In the SQL/TXT file, a 1 would be stored as an ASCII character (or whatever encoding you use). In the DB itself, the 1 could be stored as a float, int, etc. Each of these takes up a different amount of space, and none of them are likely to be exactly the same amount of space that an ASCII 1 takes up.

teammatt3 — Wed, 14 Jun 2006 01:20:10 +0000

Quote: Just because the SQL file is 150MB doesn't mean the SQL DB itself will be.

A little off topic: Is that because of the excess white space inside the backup txt file?

timjpriebe — Tue, 13 Jun 2006 12:08:29 +0000

Just because the SQL file is 150MB doesn't mean the SQL DB itself will be. Do as others have suggested, and restore the backup one table at a time. Keep checking the DB size as you get closer to the end and see if you're getting too close.

If you are pretty close at the end, you'll want to switch hosts before too long to allow for more expansion of your database. That switch should be made before you hit the DB space limit on your current server.

daredevil — Fri, 02 Jun 2006 06:01:39 +0000

u need to perform this operation one by one and not all at one go .

Daniel Malone — Tue, 30 May 2006 22:27:40 +0000

I think that in MySQL 5.2 you can have 1 table over several databases.

ablaye — Sun, 21 May 2006 16:56:31 +0000

lordmenace wrote: No, I have 1 sql file witch is 150mb my host only gives me 100mb per mysql. Is it possible to split it into 2 databases. I know nothing about MYSQl. Is it possible?

Can you pay extra to upgrade your hosting package for a larger SQL DB? If not, I know hosting companies where you can do that so you might consider moving.

StarofWars.com — Wed, 17 May 2006 23:21:02 +0000

I *think*, he means he already has a backup, he just can't use it because his host doesn't allow it to be that big.

Lord Maverick — Wed, 17 May 2006 23:17:47 +0000

It will be better for you to change hoster.

JeevesBond — Mon, 01 May 2006 11:57:57 +0000

Well as Greg mentioned, you can backup each table individually. How are you backing-up at the moment and what tools are you using?

lordmenace — Sun, 30 Apr 2006 05:41:49 +0000

Anyone know of a free remotely hosted database? All I need is 150 mb...