Problems?

Jordan · Jul 2, 2003

Originally posted by Super-Supra
Jordan. What do you mean by completely new server?

Do you mean you would have to start from scratch?

No, everything would simply be transferred over to a much more powerful server. A lot of work, and extremely expensive, but it's probably my best option.

qjasonp · Jul 2, 2003

Well what ever you do,good luck on it.Even if it messes up ever now and again this is still by far the best forum I'v ever been on.

Shannon · Jul 2, 2003

Originally posted by Jordan
No, everything would simply be transferred over to a much more powerful server. A lot of work, and extremely expensive, but it's probably my best option.

Yay! Better sever. How much is the server going to set you back Jordan?

Thio · Jul 2, 2003

Originally posted by Jordan
No, everything would simply be transferred over to a much more powerful server. A lot of work, and extremely expensive, but it's probably my best option.

I feel guilty just sitting here and watching you do this for us ...

anywayz ...

What's wrong with the old server? Is it just outdated?

Duke · Jul 2, 2003

Jordan, if there's anything we can do to help - voluntary donations, subscription service, anything like that - please let us know. I've gotten a lot from this forum and I'm more than willing to give some back. Thanks!

uke

milefile · Jul 2, 2003

Jordan: If you were to set up a "Donate" link I would contribute. I'm sure many others would to. You could do Paypal without to much trouble.

Pako · Jul 2, 2003

A Paypal donation link would be a great idea! What kind of server are you looking at Jordan?

F1man · Jul 2, 2003

Originally posted by Jordan
No, everything would simply be transferred over to a much more powerful server. A lot of work, and extremely expensive, but it's probably my best option.

Jeez Jordan, you're gonna spend that much money for us?

You're a pal.

Does this mean we will have to re-register? :banghead:

Jpec07 · Jul 2, 2003

Originally posted by F1man
Jeez Jordan, you're gonna spend that much money for us? You're a pal.

Does this mean we will have to re-register?

Agreed. But unless the registration files and such are floating around in the server's virtual memory, I don't think It'll be a problem.

BTW, I'd be glad to give back to the forum even 10 fold what I've gotten out of it, if I had anything to give (I'm plum broke and living under my parents' roof)...

F1man · Jul 3, 2003

Originally posted by Jpec07
Agreed. But unless the registration files and such are floating around in the server's virtual memory, I don't think It'll be a problem.

BTW, I'd be glad to give back to the forum even 10 fold what I've gotten out of it, if I had anything to give (I'm plum broke and living under my parents' roof)...

Yeah. But where can you find the database? I know a good deal about forum software but I have no clue about the database. :confused:

Jordan, How about a donation button somewhere on this site? I'll be glad to donate at least $20.00

GilesGuthrie · Jul 3, 2003

Originally posted by F1man
Yeah. But where can you find the database? I know a good deal about forum software but I have no clue about the database.

You wouldn't need to find the database. You would go into the MySQL Manager, and export the entire database to a single file. Then you would (on the new server) create a blank database with the same name as the original GTP database. This would create an empty shell, and you'd then restore the exported database into that shell. It would recreate all the tables, the threads, polls, posts, members, attachments, avatars, everything. All from that one file. Obviously, that's one massive file, but it would work.

That's the way I would do it, anyway. Having just done exactly the same thing on my client's procurement database in MS SQL 2000.

skylineGTR_guy · Jul 3, 2003

how much space does GTP take up anyway? I mean with all of our attaching files and all these threads.....

Jpec07 · Jul 3, 2003

Originally posted by GilesGuthrie
You wouldn't need to find the database. You would go into the MySQL Manager, and export the entire database to a single file. Then you would (on the new server) create a blank database with the same name as the original GTP database. This would create an empty shell, and you'd then restore the exported database into that shell. It would recreate all the tables, the threads, polls, posts, members, attachments, avatars, everything. All from that one file. Obviously, that's one massive file, but it would work.

That's the way I would do it, anyway. Having just done exactly the same thing on my client's procurement database in MS SQL 2000.

The qestion is how would the file be transfered? I mean, we're talking gigabytes of stuff here. Even with the fiber-optics cables that they run under the oceans, that would take a crapload of time...

Jpec07 · Jul 3, 2003

Responding to skylineGTR_Guy:
I'd say at least 2GB...

Pako · Jul 3, 2003

Originally posted by Jpec07
The qestion is how would the file be transfered? I mean, we're talking gigabytes of stuff here. Even with the fiber-optics cables that they run under the oceans, that would take a crapload of time...

From web server to web server I transfered a 250mb file in under 30 seconds..., it won't take that long...

GilesGuthrie · Jul 3, 2003

Originally posted by Jpec07
The qestion is how would the file be transfered? I mean, we're talking gigabytes of stuff here. Even with the fiber-optics cables that they run under the oceans, that would take a crapload of time...

Naah, not really. If you're putting in a new server, you'd speak nicely to your web host, and they would transfer the files between the boxes at 100Mb (LAN speed). It wouldn't take that long.

Oh, and the Attachments database alone is over 2GB. :eek:

skylineGTR_guy · Jul 3, 2003

Originally posted by GilesGuthrie
Naah, not really. If you're putting in a new server, you'd speak nicely to your web host, and they would transfer the files between the boxes at 100Mb (LAN speed). It wouldn't take that long.

Oh, and the Attachments database alone is over 2GB.

wow....good thing we can link images or it would be even bigger..

milefile · Jul 3, 2003

We should only be able to link images. Or maybe Jordan could dedicate his old server to image hosting?

skylineGTR_guy · Jul 3, 2003

nah linking is fine....except for when stupid websites wont let you link them....like that stupid "this image is hoted by tripod" image....

Jpec07 · Jul 3, 2003

Originally posted by milefile
We should only be able to link images. Or maybe Jordan could dedicate his old server to image hosting?

He's probably gonna have to sell it in order to cover for the new one...

sn00pie · Jul 3, 2003

Originally posted by Jpec07
He's probably gonna have to sell it in order to cover for the new one...

I'm pretty sure he's going to have to sell his car, too.

Yep.

Jpec07 · Jul 3, 2003

Sad, but servers aren't that expensive, are they?

sn00pie · Jul 3, 2003

Originally posted by Jpec07
Sad, but servers aren't that expensive, are they?

Webmasters need government funding these days.

Yep.

milefile · Jul 3, 2003

Originally posted by sn00pie
Webmasters need government funding these days.

Yep.

Spoken like a European.

F1man · Jul 3, 2003

Originally posted by GilesGuthrie
You wouldn't need to find the database. You would go into the MySQL Manager, and export the entire database to a single file. Then you would (on the new server) create a blank database with the same name as the original GTP database. This would create an empty shell, and you'd then restore the exported database into that shell. It would recreate all the tables, the threads, polls, posts, members, attachments, avatars, everything. All from that one file. Obviously, that's one massive file, but it would work.

That's the way I would do it, anyway. Having just done exactly the same thing on my client's procurement database in MS SQL 2000.

I was not thinking about the MySQL database when I made that post. :banghead:

PS. Jordan, please don't sell your car just for us!

You do too much for us already.

milefile · Jul 3, 2003

Well mySQL isn't a database either. It's a "server querry language".

F1man · Jul 3, 2003

Originally posted by milefile
Well mySQL isn't a database either. It's a "server querry language".

Yeah. And PHP used to stand for "Personal Home Page" but now it stands for "Hypertext Preprocessor" Please excuse me. I'm mainly a PHP person.

GilesGuthrie · Jul 3, 2003

Originally posted by milefile
Well mySQL isn't a database either. It's a "server querry language".

Hmm. Since we're picking nits, isn't it "Structured Query Language"?

And I bet you're the sort of person who refers to it as ess queue ell, aren't you?!

milefile · Jul 3, 2003

You got me.

Pako · Jul 3, 2003

So how many "SEQUAL" people do we have out there?

Count me for one...

Problems?

Jordan

Site Founder

qjasonp

Shannon

Thio

Duke

Keep 'em separated

milefile

Pako

F1man

Jpec07

F1man

GilesGuthrie

skylineGTR_guy

Jpec07

Jpec07

Pako

GilesGuthrie

skylineGTR_guy

milefile

skylineGTR_guy

Jpec07

sn00pie

AAAH DON'T PANIC!!!

Jpec07

sn00pie

AAAH DON'T PANIC!!!

milefile

F1man

milefile

F1man

GilesGuthrie

milefile

Pako

Similar threads

Latest Posts