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..
Navigation
User login
Advertisers
aPaddedCell © Copyright 2006-2007 InterMedia. Site and all articles (unless otherwise specified) licensed under a Creative Commons License.
Greg K posted this at 07:21—29th April 2006.
He has: 1,606 posts
Joined: Nov 2003
Are you backing up the entire database at once? If so, try backing up each table individually.
-Greg
[This space intentionally left blank]
Cool Geek Supplies: www.ThinkGeek.com
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.
Find Freelance Web Programmers & Graphic Designers for less @ Project4Hire.com
WebSorter Web Directory - Add your website today!
Computers and Consumer Electronics Forums
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,489 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?
a Padded Cell our articles site!
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.
StarofWars.com | Star Wars Fansite and Community
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.
Daniel Malone works on DanielJMalone.com daily.
DanielJMalone.com likes Webmasters Forums
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,666 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: 1,831 posts
Joined: Sep 2003
A little off topic: Is that because of the excess white space inside the backup txt file?
My Site | Regular Expression Tester
timjpriebe posted this at 13:03—14th June 2006.
He has: 2,666 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