| Author |
 Topic  |
|
123456
New Member
75 Posts |
 Posted - 06 July 2003 : 22:21:29
|
Hello,
Recently I was given the chance to take over a website that has around 5000 members on their Snitz forum. Well long story short the people in charge wanted the board deleted from the site. Right now it's been blocked so that no one can get to it. I thought they would let me put it back up, but they will not. So now here I am getting hammered with emails asking about the board and all that.
So I would like to move the forum elsewhere and let the people post on it.
I know how to maintain websites and all that, but this message board thing is totally new to me.
My website is based off this host:
http://www.snaphost.com/default.asp
1st question:
Do they have what I need to run the forum on their server?
Thanks!
A newbie in the highest regards :) |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 06 July 2003 : 22:27:55
|
Yes they do 
You can use an Access or MySql Database, MySql will allow for more concurrent users and a larger size, Access is easier to setup. |
 |
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 06 July 2003 : 22:29:09
|
| And She beat me again... |
|
|
|
123456
New Member
75 Posts |
Posted - 06 July 2003 : 22:39:00
|
Hmmmm Where to start? haha
Let's see.......
Okay when I go to the original site, there's like ten billion files in there and the board is in there.
There are two files board, and Board_gone
The board file when I view it in my FTP says it's just a redirect file, which is how they took the board off the site. They renamed the main board file to board_gone. So now I can type in www.siteaddress.com/board_gone and still access it. Well I transferred the board_gone file to my FTP, and then sent it to my website. I thought I did everything correct like choosing the right ways to connect to the board,
strDBType = "mysql"
I had to take the ' off the front right?
Then I went here:
strConnString = "driver=MySQL;server=I put my server here!;uid=I put my ID here;pwd=I put my password here;database=mdbfile name here" '## MySQL
Removed the ' from the 'strConnString part right?
Now i'm stuck, what the heck do I do now?
|
Edited by - 123456 on 06 July 2003 22:42:31 |
|
|
|
123456
New Member
75 Posts |
Posted - 06 July 2003 : 22:41:13
|
quote:
Originally posted by Dave6625
Yes they do
You can use an Access or MySql Database, MySql will allow for more concurrent users and a larger size, Access is easier to setup.
Sounds good, but what's an Access or MySql Database?
haha
I really have no clue what either is...so any help would be madly appreciated. |
|
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 06 July 2003 : 22:43:49
|
You might want to start be creating a \forum folder and uploading all the files there. then you need to create all the Snitz tables in the MySql database, you might search in the MySql forum for info on how to go about that one.
You config.asp does look correct except sfbrddb.mdb, unless you name your database sfbrddb.mdb, it won't be like that, it would just be a name, no extension. |
|
|
|
123456
New Member
75 Posts |
Posted - 06 July 2003 : 22:44:20
|
| Also there's 4 .mdb files in the site, I transferred the most recent one. That was correct, right? |
|
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 06 July 2003 : 22:46:55
|
quote:
Originally posted by 123456
quote:
Originally posted by Dave6625
Yes they do
You can use an Access or MySql Database, MySql will allow for more concurrent users and a larger size, Access is easier to setup.
Sounds good, but what's an Access or MySql Database?
haha
I really have no clue what either is...so any help would be madly appreciated.
They are two different types of databases (this is where all the posts/topics/user info is stored. an Access database is a file on the server (usually with a .MDB extension, and a MySql DB is a database that is more like a program (not a file on the server like an Access database is), MySql can handle more connections and a larger size than Access. You may need to contact your host to get a database setup for you. |
|
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 06 July 2003 : 22:48:16
|
quote:
Originally posted by 123456
Also there's 4 .mdb files in the site, I transferred the most recent one. That was correct, right?
huh? Are you planning to use an old database or a fresh one? are you sure those database's were for Snitz? |
|
|
|
123456
New Member
75 Posts |
Posted - 06 July 2003 : 22:58:14
|
That's pretty much where I think this is going, cause i've done everything that's been said to do regarding this.
I do want to keep every member and post intact for the new location. Basically I want it to remain exactly as is.
Database....hmmmm
Well this is what i've done for the new webhost. I secured a domain name (should be active in a day or so) and then secured the host IP, (I can access that now).....So this site is totally new for me.
The only thing on the new site is the aspnet_client file(with all the Snitz pics and guts of the program), and the mdb file.
I'll use a fresh one or an old one, whichever works as long as it keeps the members and posts. BUT i'm not sure what a database is now that you mention it. The host says that the site has one, but is that something they have to add or is it already there?
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 06 July 2003 : 23:05:11
|
All of your snitz posts, users, etc., are stored in a database. You mentioned a .mdb file, that's an Access database file and you will want to preserve the .mdb off your old site. If you are using a SQL Server or MySQL database you will need to export everything in your current database and then import everything into a new database at your new host.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Dave.
Senior Member
USA
1037 Posts |
Posted - 06 July 2003 : 23:07:28
|
quote:
Originally posted by 123456
That's pretty much where I think this is going, cause i've done everything that's been said to do regarding this.
I do want to keep every member and post intact for the new location. Basically I want it to remain exactly as is.
Database....hmmmm
Well this is what i've done for the new webhost. I secured a domain name (should be active in a day or so) and then secured the host IP, (I can access that now).....So this site is totally new for me.
The only thing on the new site is the aspnet_client file(with all the Snitz pics and guts of the program), and the mdb file.
I'll use a fresh one or an old one, whichever works as long as it keeps the members and posts. BUT i'm not sure what a database is now that you mention it. The host says that the site has one, but is that something they have to add or is it already there?
(I'm a little confused)
When you say that you have an aspnet_client file, do you mean aspnet_client folder?
Well you need to have the old database, if you have it and it's a .mdb file, then it's an Access database. Setup config.asp to use access and an Access StrConnString. You can then upgrade to MySql later if you want.
A database is where all the data for the forum is stored, all the configuration settings, and all the posts/topic's etc.
OK so lets work from there... |
|
|
|
123456
New Member
75 Posts |
Posted - 06 July 2003 : 23:10:09
|
quote:
Originally posted by Doug G
All of your snitz posts, users, etc., are stored in a database. You mentioned a .mdb file, that's an Access database file and you will want to preserve the .mdb off your old site. If you are using a SQL Server or MySQL database you will need to export everything in your current database and then import everything into a new database at your new host.
What exactly is a MySql database? I've been browsing the Mysql.com, but I think I want something just spilled out in caveman terms here.....haha
How do I go about importing a new database? Does that mean just FTP the file off the old site and then send it to the new one? Or do I ahve to do something to it in some program and then afterwards FTP it to the new one?
(YOU guy rock BTW, I didn't expect to get this much help this fast) |
|
|
|
123456
New Member
75 Posts |
Posted - 06 July 2003 : 23:15:25
|
quote:
(I'm a little confused)
ME too....haha
quote:
When you say that you have an aspnet_client file, do you mean aspnet_client folder?
Yes, when I connect to the original location there's an aspnet_client folder which I transferred to the new location.
quote:
Well you need to have the old database, if you have it and it's a .mdb file, then it's an Access database.
It is.
quote:
Setup config.asp to use access and an Access StrConnString. You can then upgrade to MySql later if you want.
Will give it a shot.
|
|
|
|
123456
New Member
75 Posts |
Posted - 07 July 2003 : 00:59:12
|
Alright, i've got the board set up exactly as it is on the original board.......and when I type in the site address 111.111.111.111/board_gone
I get this error;
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'getCurrentIcon'
/board_gone/inc_header.asp, line 257
Any clue? |
Edited by - 123456 on 07 July 2003 02:19:43 |
|
|
|
Topic |
|
Topic Locked
