Page 1 of 1
help!! How to use createDatabase.sql build mysql
Posted: 16 Jul 2013, 11:42
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 ?
Re: help!! How to use createDatabase.sql build mysql
Posted: 16 Jul 2013, 11:50
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
Re: help!! How to use createDatabase.sql build mysql
Posted: 16 Jul 2013, 14:54
by Crush
Moved from Off Topic to Manasource Development
Re: help!! How to use createDatabase.sql build mysql
Posted: 16 Jul 2013, 16:42
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