I'm Having Issues! Restoring a fair sized database

strauss1 · August 29th, 2003, 3:04 AM

At the risk of sounding like a spaz, I'm having issues and I'm about to kick this damn laptop out the window.

I run a fair sized phpBB community and am trying to get everything from the CURRENT server onto a server over here. Last time I transferred the community, I restored the database table by table, and ended up manually breaking everything up into sections because of size and timeouts. Needless to say, it took a while and I'm not looking forward to doing it again. :ph34r:

I'd be willing to use (read: learn) telnet or ssh, but don't have a clue where to start with that (my backup is already uploaded to a backup directory if that helps...?). I definitely need something faster and/or more efficient because this community is expanding quite swiftly and the thought of having to restore this database for whatever reason again is sending me close to convusions.

I guess I'm just asking for any ideas, as I'm not familiar with my options. ANYTHING to keep from having to do it manually through phpMyAdmin again. *shudder*

So, let's hear it.

Anyone? :thinking:

LordUppity · August 29th, 2003, 6:04 PM

If you don't already have Shell access, there is a cost. (http://www.surpasshosting.com/addon.shtml)

Too bad we aren't allowed to connect to the SQL server remotely, otherwise I could recommend a brilliant freeware program, which would upload your sql database within seconds.

**patrickb** · August 30th, 2003, 5:37 PM

Even if you did have access to SSH/telnet, you couldn't upload the actual SQL files, because they have SSH jailed tight, and you can't directly access the mySql database directory. At least that's what I think I remember...

Try sending in a support ticket and asking them if they could move the database to the mysql directory for you, then you could just put it in some directory on your website and tell them where to find it at. I believe they would do that for you...

August 29th, 2003, 3:04 AM	#1 (permalink)
strauss1 Registered User Fresh Surpasser Joined in Jul 2003 Lives in Juneau, Alaska USA Hosted on Mecca, Bee, Mango 13 posts Gave thanks: 0 Thanked 0 times	At the risk of sounding like a spaz, I'm having issues and I'm about to kick this damn laptop out the window. I run a fair sized phpBB community and am trying to get everything from the CURRENT server onto a server over here. Last time I transferred the community, I restored the database table by table, and ended up manually breaking everything up into sections because of size and timeouts. Needless to say, it took a while and I'm not looking forward to doing it again. :ph34r: I'd be willing to use (read: learn) telnet or ssh, but don't have a clue where to start with that (my backup is already uploaded to a backup directory if that helps...?). I definitely need something faster and/or more efficient because this community is expanding quite swiftly and the thought of having to restore this database for whatever reason again is sending me close to convusions. I guess I'm just asking for any ideas, as I'm not familiar with my options. ANYTHING to keep from having to do it manually through phpMyAdmin again. shudder So, let's hear it. Anyone? :thinking: __________________ Steph http://www.thebeautybottle.com ~ Bee http://www.longhaircommunity.com ~ Mecca http://www.scrumbalicious.com ~ Mango

August 30th, 2003, 5:37 PM	#3 (permalink)
patrickb the one who was Super #1 Joined in Jul 2003 Lives in Memphis 1,967 posts Gave thanks: 0 Thanked 3 times	Even if you did have access to SSH/telnet, you couldn't upload the actual SQL files, because they have SSH jailed tight, and you can't directly access the mySql database directory. At least that's what I think I remember... Try sending in a support ticket and asking them if they could move the database to the mysql directory for you, then you could just put it in some directory on your website and tell them where to find it at. I believe they would do that for you... __________________ Patrick Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

August 29th, 2003, 6:04 PM	#2 (permalink)
LordUppity Registered User Fresh Surpasser Joined in Aug 2003 Hosted on D19 7 posts Gave thanks: 1 Thanked 0 times	If you don't already have Shell access, there is a cost. (http://www.surpasshosting.com/addon.shtml) Too bad we aren't allowed to connect to the SQL server remotely, otherwise I could recommend a brilliant freeware program, which would upload your sql database within seconds.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)