help!! How to use createDatabase.sql build mysql

The 2009 Mana project went dormant around 2014 and was revived in 2023; it currently develops a client implementation for TMW and potentially other games.


Post Reply
fatalfeel
Peon
Peon
Posts: 21
Joined: 27 Mar 2012, 13:44

help!! How to use createDatabase.sql build mysql

Post by fatalfeel »

Dear All:

nice to meet you and tks for ur email

now have a new question, no document can find, plz help me

http://doc.manasource.org/database_inst ... ?s[]=mysql

C:\mana_alphainfo\server\src\sql\mysql

1.createDatabase.sql

2.createTables.sql


how to use 1. createDatabase.sql ?
Ablu
Manasource
Manasource
Posts: 288
Joined: 23 Jul 2011, 08:31
Location: Germany

Re: help!! How to use createDatabase.sql build mysql

Post by Ablu »

For mysql you first need to create a database (either you do it yourself and set your values in the manaserv config or you use our createDatabase.sql script). And then create the tables (via createTables.sql) in it. To run those sql scripts you can use your preferred sql client / database viewer (I do not know what is used on windows usually. On linux I usually use the mysql commandline client.

EDIT: If you generally wonder about how the SQL scripts work mysql is probably the wrong choice for you. It is maybe better if you learn a bit about mysql setups before or simply use sqlite ;)

Regards,
Ablu
User avatar
Crush
TMW Adviser
TMW Adviser
Posts: 8046
Joined: 25 Aug 2005, 16:08
Location: Germany

Re: help!! How to use createDatabase.sql build mysql

Post by Crush »

Moved from Off Topic to Manasource Development
  • former Manasource Programmer
  • former TMW Pixel artist
  • NOT a game master

Please do not send me any inquiries regarding player accounts on TMW.


You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
fatalfeel
Peon
Peon
Posts: 21
Joined: 27 Mar 2012, 13:44

Re: help!! How to use createDatabase.sql build mysql

Post by fatalfeel »

tks a lot
Ablu wrote:For mysql you first need to create a database (either you do it yourself and set your values in the manaserv config or you use our createDatabase.sql script). And then create the tables (via createTables.sql) in it. To run those sql scripts you can use your preferred sql client / database viewer (I do not know what is used on windows usually. On linux I usually use the mysql commandline client.

EDIT: If you generally wonder about how the SQL scripts work mysql is probably the wrong choice for you. It is maybe better if you learn a bit about mysql setups before or simply use sqlite ;)

Regards,
Ablu
Post Reply