My Community

As long as WoW Mod requires MySQL database some people are having problems with this kind of database.

First of all, MySQL database is more than just a file like SQLite.
In order to use MySQL db first of all you need a server to be installed on. The best choice is to have MySQL server and SRCDS server on same computers, but they can be different as long as latency between those computers is enough small for lagless game.

Most game servers providers do not give MySQL as default feature for CS:S Servers (This is because only few plugins require MySQL)
But almost all of those providers are working inside of the bigger companies which provide such feature as web hosting. With webhosting almost all the hosters provide MySQL as free feature.
If you are confused, contact support service asking for MySQL server.

If you are required to install MySQL software yourself then here is the instruction:
Get MySQL itself, here is the link you can get downloads: http://dev.mysql.com/downloads/mysql/5.1.html
This version is 5.1, one of the stablests.
Download the file which suits your OS and processor.

Launch the file and follow instructions, when you will be asked about configurations, take the one which supports MyISAM with the best perfomance (by default this one is chosen already)
Tick the box which will add mysql commands to your OS shell (This is required to easier creation of database)
Do not forget to put password for root in order to be secured

Now you're finished with installation, only creating database is left
Since we have mysql commands right in our shell just press button Start and press "Run"
Type there: cmd   and press enter
Black window will appear, don't get scared
Run following command to create database:
mysqladmin create databaseName --user=userName --password=userPassword
As an example:
mysqladmin create wow --user=root --password=my_pass
If you did everything correct it will create database and now you are able to launch wow mod.

I don't have any experience with SQL, but being head admin on the server I would like to get a backup of the user database occasionally, we've had instances where the server host would have to do a rollback, and in the past some people have lost hundreds of levels (and occasionally they are adamant about getting them back).  How would I do this?  Yes I do have FTP access to the server.

Quote from: Jitters on October 18, 2009, 01:11:03 PM

I don't have any experience with SQL, but being head admin on the server I would like to get a backup of the user database occasionally, we've had instances where the server host would have to do a rollback, and in the past some people have lost hundreds of levels (and occasionally they are adamant about getting them back).  How would I do this?  Yes I do have FTP access to the server.

backup scripts have nothing to do with wow actually.
Free and pretty good backup program is available from mysql.com and called "mysql tools" as i remember. You set up period and what tables to backup, you will need access to mysql server though. Professional mysql servers should already have some sort of backup - you could ask the mysql administration about it.

Also, you can just backup the files you really need occasionally.  Such as the races, ultimates, and levels... if any changes were done to any of those.  Anyways, that is more simple then backing up everything.  However, hope everything works out for you.

Don't forget it is WoW section.

What should I put as a host adress?

host adress of what?

Webfiles are extra, you can upload them for extra features but I'd advice first of all get the mod run.