My database backup is too big.
Hi. I have a database backup which is 150 mb. My host only allows a max of 100 mb in a MYSQL database. What are my options to resotre my old database (IPB forums) to my new host? I don't want to loose 10,000 members..
Hi. I have a database backup which is 150 mb. My host only allows a max of 100 mb in a MYSQL database. What are my options to resotre my old database (IPB forums) to my new host? I don't want to loose 10,000 members..
Greg K posted this at 07:21 — 29th April 2006.
He has: 2,145 posts
Joined: Nov 2003
Are you backing up the entire database at once? If so, try backing up each table individually.
-Greg
lordmenace posted this at 17:22 — 29th April 2006.
They have: 9 posts
Joined: Apr 2006
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?
ablaye posted this at 16:56 — 21st May 2006.
They have: 140 posts
Joined: Apr 2006
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.
lordmenace posted this at 05:41 — 30th April 2006.
They have: 9 posts
Joined: Apr 2006
Anyone know of a free remotely hosted database? All I need is 150 mb...
JeevesBond posted this at 11:57 — 1st May 2006.
He has: 3,956 posts
Joined: Jun 2002
Well as Greg mentioned, you can backup each table individually. How are you backing-up at the moment and what tools are you using?
Lord Maverick posted this at 23:17 — 17th May 2006.
They have: 34 posts
Joined: May 2006
It will be better for you to change hoster.
StarofWars.com posted this at 23:21 — 17th May 2006.
He has: 19 posts
Joined: May 2006
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.
Daniel Malone posted this at 22:27 — 30th May 2006.
They have: 2 posts
Joined: May 2006
I think that in MySQL 5.2 you can have 1 table over several databases.
daredevil posted this at 06:01 — 2nd June 2006.
They have: 7 posts
Joined: Jun 2006
u need to perform this operation one by one and not all at one go .
timjpriebe posted this at 12:08 — 13th June 2006.
He has: 2,667 posts
Joined: Dec 2004
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.
Tim
http://www.tandswebdesign.com
teammatt3 posted this at 01:20 — 14th June 2006.
He has: 2,102 posts
Joined: Sep 2003
A little off topic: Is that because of the excess white space inside the backup txt file?
timjpriebe posted this at 13:03 — 14th June 2006.
He has: 2,667 posts
Joined: Dec 2004
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.
Tim
http://www.tandswebdesign.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.