Creating a sample MySQL database

First, you need to generate an instance for sample game database. In order to do this, you need to have MySQL installed in your system. The current version is based on MySQL 5.1. You need to download or purchase MySQL from http://www.mysql.com. (Alert! MySQL is a premium software that you need to purchase if you are using it for any commercial purposes. Please contact MySQL if you have any licensing related questions.)

If you want to use MySQL more easily in GUI environment, we recommend you to use it together with tools like SqlYog and etc. You can either download or purchase SqlYog from http://www.webyog.com.

Install MySQL

  • You need to set a password when installing MySQL. The samples included in ProudNet sample that use MySQL have their password hardcoded.
  • At installation, we recommend you to set the basic character set of MySQL instance as utf8/utf8_generic_ci. But if you insist using other character set, then set the character set of database instance that accesses ProudDB as utf8/utf8_generic_ci.
mysql_collate_set.png
Language Setting in MySQL

Now you need to install DB Schema

  • Schema gets generated by running .sql file included in <Installed folder>/ProudNet/Samples/DbmsSchema/MYSQL. But, run .sql files with their name as “proc” in later.

You may see the following format when you complete in creating a database.

db_sample_schema_mysql.png
Example of Sample Database Installation Completion.

The generated tables should have fields named as FieldA, FieldB and etc. These fields are only being used in the sample sources so please feel free to remove them if you want.