Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Previous versions
 Need Help Please		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

NelsonR
Starting Member

7 Posts
Posted - 14 November 2007 :  18:40:26  Show Profile
Hi,
I hope you can help me out here, i need to move my forum to a new hosting company called 1&1 Internet Inc. my question is can i just move all the files over to the new host or is there a need to prepare things for the move? (Snitz Forums 2000 Version 3.4.03) there are 33985 posts and i don't want to risk loosing them and all the registered members. Could i copy all the files and folders and try it on the new host and leave the forum where it is without effecting the forum on the old host? i would rely appreciate any help you can give me.

Thanks in advance
Nelson

phy1729
Average Member

USA
589 Posts
Posted - 14 November 2007 :  18:49:52  Show Profile
If you copy all the files it will not affect the forum on the old host but to get it working on the new host we need to know which database you are using. And, welcome to Snitz.
Go to Top of Page

NelsonR
Starting Member

7 Posts
Posted - 14 November 2007 :  22:50:12  Show Profile
Hi, phy1729
Thanks it’s nice to be part of the Snitz Forum. I’m very new to this how can I tell which database I’m using?
Go to Top of Page

phy1729
Average Member

USA
589 Posts
Posted - 14 November 2007 :  23:01:03  Show Profile
In config.asp their are three lines that start with strDBType = . One of those lines is uncommented (doesn't have a ' in front of it). We need to know what that one says. ex.

'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"

'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!

If this is your file we would need to know Access (in red) is uncommented.
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts
Posted - 15 November 2007 :  11:46:51  Show Profile  Send pdrg a Yahoo! Message
Hi and welcome NelsonR,

phy1729 is right on the ball asking about db type, it'll massively influence how to approach this, but for what it's worth, I'll nag - BACK EVERYTHING UP AND CHECK YOUR BACKUPS! Seriously, I've worked for huge companies who wish they'd taken heed of this simple advice, so at every stage until you have your new forum running safely for a week or more, back up files at every stage and change. I hope you don't have to thank me for forcing you to do this, and that everything goes smoothly!

Also, just confirm that your 1&1 host account supports ASP, and let's find out what DB options they offer you (MSSQL, MySQL, Access?) - this may be a good time to upgrade your db as well as upgrade your Snitz files to the latest 3.4.06 and add the security patches

Anyway, I'll butt out now and leave you in phy1729's capable hands a while ... ;-)
Go to Top of Page

NelsonR
Starting Member

7 Posts
Posted - 15 November 2007 :  20:52:06  Show Profile
Hi phy1729, this is a copy of the config.asp file.
and thanks for the advice pdrg.

'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
Go to Top of Page

phy1729
Average Member

USA
589 Posts
Posted - 15 November 2007 :  21:29:26  Show Profile
Ah access much easier. So all you need to do is copy all the files and the database to the new host. If you don't know where the db is you can find where it is by looking in config.asp again and finding these lines (51-6) and find the one that doesn't start with a ' .

'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\db\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97

In the line that doesn't start with a ' find the part that I have highlighted in green this will be diffrent for you and that part will be the path to your database. Copy the db to the new host to the same path. Post if you don't understand what I said.
Warning:Do not post the code here. It may open your forum to attack
Also as pdrg caught, make sure you are hosted on a Windows server at 1&1 not a Linux because Linux does not support ASP.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07