| Author |
 Topic  |
|
jo.breame
Starting Member
4 Posts |
 Posted - 22 November 2005 : 03:40:13
|
Hi
I installed Snitz at work and intrgetaed it into the compnay website on there own webserver. I used Access and it worked great.
I now want to use snitz for a personal project. My website will be on a third party web host server and I also want to use mysql rather than access due to size, but I haven't got a clue where to start. How do I create a mysql database... and how do I go about hosting the database and my forum online.
Do I need to install some sql software on the computer on which I am designing the site?
Thanks, I know these are prob stupid questions!
Jo
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 22 November 2005 : 04:29:07
|
quote:
Originally posted by jo.breame
I also want to use mysql rather than access due to size,
MtSQL will be no smaller than an access database/mdb file (or if it is, it'll be negligible), and unless it's going to be a particularly big and busy db, again MySQL doesn't offer you much advantage imho.
quote:
Originally posted by jo.breame
Do I need to install some sql software on the computer on which I am designing the site?
If you want to use a MySQL db, you'll probably want to install MySQL locally - look for it at sf.net - it'll be easier to have a design and test environment similar to your deployment environment. again, imvho  |
 |
|
|
jo.breame
Starting Member
4 Posts |
Posted - 22 November 2005 : 06:13:39
|
The forum is potenmtially going to be extremely busy. Is there a feasable backend I could use, bearing in mind I am a complete novice?
If so woudl you be kind enough to talk me through simply step by step the stages...
Thank ;) |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
Posted - 22 November 2005 : 06:34:13
|
quote:
My website will be on a third party web host server and I also want to use mysql rather than access due to size, but I haven't got a clue where to start.
I take it that you haven't got hosting yet. If so, I would suggest that you look for a host which provides MSSQL (Sql Server), especially if you envision that you will have a very busy forum. The host should provide you with instructions regarding connecting to your database whether its MySql or MSSql. |
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts. |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 22 November 2005 : 10:24:42
|
quote:
If so, I would suggest that you look for a host which provides MSSQL (Sql Server), especially if you envision that you will have a very busy forum.
Ahem, so you suggesting MySQL can't handle a very busy forum?
/me look for the Remove Moderator option in the admin panel  |
Support Snitz Forums
|
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
jo.breame
Starting Member
4 Posts |
Posted - 22 November 2005 : 11:24:57
|
Thanks, your all being very helpful 
No, I haven't thought about hosting yet. When I find a mssql host (recommend one for a poor student anyone? ) where do I configure snitz to point to to the address of my sqlhost? Can you please paste the syntax with an example of this so I can see what I am doing?
What is the max number of posts and users an access, mssql and mysql can handle then? |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
Posted - 22 November 2005 : 11:39:59
|
quote:
where do I configure snitz to point to to the address of my sqlhost?
Its a very simple change made to config.asp
quote:
What is the max number of posts and users an access, mssql and mysql can handle then?
It depends on a lot of things and opinion varies.
In my very humble opinion I would rate them in order of preference.
1. MS Sql Server 2000
2. MySql
3. Access
Using an Access database is usually free. Hosts usually charge extra for MySql & MSSql. |
Podge.
The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)
My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board
Warning: The post above or below may contain nuts. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 November 2005 : 11:47:09
|
Padraic, David was just joking. We have an ongoing "war" over MySQL vs. SQL Server and he was just afraid that I was getting an extra hand from you, I am sure .
Actually, it's probably easier to find a cheap hosting solution featuring MySQL than SQL Server. And MS's prices for SQL Server 2005 won't help improve that. Personally I'd go with SQL Server whenever I can, haven't changed my opinion on that. It's not only the DBMS itself, but also the tools and the way they interact with the server, and the tools are very important for forum maintenance. Anyway, latest versions of MySQL do bring some needed SQL support, including things like subqueries, unions and such, which helps with using MySQL in a forum or site.
Still, as I said, I'd go with SQL Server over MySQL anytime.
So, to jo.breame, pick whichever option you find more suitable, specially regarding price, if that is an important criteria. Several members here offer cheap and reliable hosting solutions, so browse the forums for info on that (hosting discussions are not allowed though). Once you get the hosting package that suits you, the Snitz readme will tell you how to connect to it. Your host will either create a DB for you or let you create one. No need to antecipate things, it's real easy to setup Snitz to use a MySQL DB. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 November 2005 : 12:12:39
|
quote:
Originally posted by Podge
I'm just a little bit stressed today. More on that later.
If I can be of help, you have my email address. Be sure that there is no reason to think David was speaking seriously. We just joke a lot in this SQL Server vs. MySQL "battle" for the hearts and souls . |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 22 November 2005 : 14:18:54
|
I was thinking Rui got a new recruit in the MySQL vs MS SQL debates, so I jumped at it.
Yeah Podge, just messing with you. Although I am unable to debate with other MS SQL fans, on how MySQL compares with MS SQL feature for feature, I basically endorse open source software and as long as it can match or compete to the big boys that cost you an arm and a leg, I'm all for it. That's my main liking for MySQL. Wish I could take on Rui on that case. Maybe someday I will, but for now, I just keep on his back whenever he mentions mysql and ms sql. 
You can always find heated arguments from both sides of the fence, by doing a search on google for "mssql vs mysql" or something like that. Sure you will find lots of info.
I think the main differences between both are price. But that's just my non-technical perspective.  |
Support Snitz Forums
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 22 November 2005 : 21:06:02
|
Just to chime in, MySQL is an excellent choice for a busy forum. MySQL is robust and stable, but yes it's difficult to find asp/windows hosts that offer mysql. Luckily my host offers both MySQL and MS SQL :)
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
jo.breame
Starting Member
4 Posts |
Posted - 23 November 2005 : 03:59:01
|
Thanks
Although there is no need to start a fight on my account...lol! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
campinmom03
Junior Member
USA
190 Posts |
|
|
Topic |
|
Topic Locked
