Ncdb
From WCell
Contents |
[edit] Creating databases for WCell server
In order to get server running, you have to create database that contains various things. Follow instructions below to success. You could also use MS SQL Server 2005 Express or PostgreSQL but in this guide we are using MySQL.
[edit] Programs needed:
Mysql 5.X ( Download )
Download, install and configure. There are so many guides available already how to do that, so just search up for one.
[edit] Configuring
For setting up the connection of WCell to your database, look at Configuration
[edit] Creating database
Launch MySQL and create 2 databases called WCellAuthServer and WCellRealmServer
So example, if you installed your mysql to C:/mysql/:
Press start, run --> cmd. On command prompt type in: cd .. ( Changes directory ) until you are in C:\. Then type in cd mysql, cd bin. You should now be in C:\mysql\bin\ or something.
Then run mysql and type in following:
mysql -u root -p
create database WCellAuthServer;
create database WCellRealmServer;
Next, you have to register account here: http://www.nc-db.info/
After you have registered account, go here: http://nc-db.info/svn/ncdb and use username and password that you just created.
Browse your way to /trunk/sql/ and download database.zip, win-install.bat and folder called changesets to your computer.
Open win-install.bat in text-editor
Find:
set user=root
set pass=password
set wdb=ncdb ( Value for this is: WCellRealmServer )
And change them to correspond your mysql login info.
Then move database.zip, win-install.bat and folder called changesets to your MySQL binary folder ( Example C:\mysql\bin\ )
Run win-install.bat and choose I to install database ( Of couse, unzip database.zip first ). After it is finished, choose to install changesets.
[edit] Final
Congratulations, you should now have 2 databases called WCellAuthServer and WCellRealmServer containing data that is needed to run your server.
