| View previous topic :: View next topic |
| Author |
Message |
pinknapkins
Joined: 25 Dec 2005
Posts: 9
|
 Posted: Wed Dec 28, 2005 3:23 Post subject: MySQL vs SQLite |
 |
|
My setup:
2 servers running on the same hard drive.
Second Server points to vault of first server (shared vault)
My question is, in this configuration, is it better to go with MySQL or SQLite?
I want to have both servers point to the same database file whichever I go with. |
|
| Back to top |
|
 |
pinknapkins
Joined: 25 Dec 2005
Posts: 9
|
| Posted: Wed Dec 28, 2005 5:25 Post subject: Update |
|
|
Ok update. I decided to go with MySQL after reading everything people were saying about it here. The only problem is, I cannot get a service instance to run.
Can someone point me in the right direction or offer some suggestions?
OS: Windows Server 2003
MySQL Ver. 5.0
I am totally stumped. I would love any help anyone could offer. Thanks. |
|
| Back to top |
|
|
Acrodania
Joined: 02 Jan 2005
Posts: 208
|
| Posted: Wed Dec 28, 2005 5:52 Post subject: |
|
|
MySQL doesn't use a "Service Instance" with a particular name like MSSQL, its a single process. You should be able to see the MySQL service in services.....
The installer normally does a good job, if it failed I'm not sure where to pont you 
You might need to add it as a trusted service as all its communications are via IP and 2003 server has a tendancy to purposely block things that you try to run. Allow connections to port 3306 and you should be fine. |
|
| Back to top |
|
|
pinknapkins
Joined: 25 Dec 2005
Posts: 9
|
| Posted: Thu Dec 29, 2005 6:06 Post subject: Some issues |
|
|
This is the error I keep getting in the log when I try to start the MySQL service:
| Quote: | 051228 19:54:25 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432
InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0
InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0
InnoDB: Page number (if stored to page already) 0,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
051228 19:54:25 [ERROR] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Got signal 11. Aborting!
051228 19:54:25 [ERROR] Aborting
051228 19:54:25 [Note] D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete |
For allowing port connections, are you referring to my router?
I tried using the tutorial: http://www.nwnx.org/index.php?id=tut2 but it didn't really apply and it didn't seem to take with MySQL 5.0.
*bangs head on desk* |
|
| Back to top |
|
|
Acrodania
Joined: 02 Jan 2005
Posts: 208
|
| Posted: Thu Dec 29, 2005 6:46 Post subject: |
|
|
Ouch, icky error, something else is wrong. Maybe you got a bad install.
I would recommend downloading version 4.1 and I know it works fine on 2003 and 2k, I haven't used 5 at all though others say it will work.
What I meant by port numbers is that server 2003 blocks ports similar to WinXP's firewall does. But that isn't the case here.... |
|
| Back to top |
|
|
pinknapkins
Joined: 25 Dec 2005
Posts: 9
|
| Posted: Mon Jan 09, 2006 23:24 Post subject: |
|
|
| 4.1 did the trick btw. Thanks. |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
