MySQL How to setup a MySQL Database (screenshots included) - Last update: 16/7/2009

[Delirium]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

Check the second part of the tutorial,if errors appear

 

[kemosavi]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

great guide man saved me alot of trouble

 

[Kanon]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

Very nice

 

[Chromium]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

i get stuck at the cmd part. I type C:xampp_realmysql -u root otserv -p < triggers.sql and they write that C:xampp_realmysql is not recognised as an internal or external command, openable program or batch file and i already cd-ed to the folder where i have the otserv

 

[Delirium]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

i get stuck at the cmd part. I type C:xampp_realmysql -u root otserv -p < triggers.sql and they write that C:xampp_realmysql is not recognised as an internal or external command, openable program or batch file and i already cd-ed to the folder where i have the otserv

The second part of the tutorial was written by talaturen,i'm not familliar with the triggers thing

 

[Chromium]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

ok thanks for the guide anyways

 

[mikeware]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

Good one, gratz


need some help in some steps but okay i guess im going good

 

[mikeware]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

Good one, gratz


need some help in some steps but okay i guess im going good

 

[Datascalvo]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

Nevermind any longer, I solved it myself

 

[Apollo]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

help..

Error
SQL query:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `account` = OLD.`id` ;



MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR ' at line 1

 

[Apollo]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

how can I edit accounts and stuff?

 

[Mark]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

Seems like you didn't read mysql-help or IMPORTANT.txt, you should NOT use phpMyAdmin to import the database structure.

 

[Datascalvo]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

Seems like you didn't read mysql-help or IMPORTANT.txt, you should NOT use phpMyAdmin to import the database structure.

It's the third step of this tutorial where you import forgottenserver.sql. I'm having the same problem tho, but I can run the server later on without any problems (beside the versions items.otb that I have to put in and the houses loading error which I can fix later on )

 

[BrasseN]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

A problem.
When i tried to Import forgottenserver.sql ( as you said ) and i clicked "Go", then this shows:

Error

SQL query:

DROP TRIGGER IF EXISTS `oncreate_players` ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS `oncreate_players`' at line 1


what's wrong? can't understand that ( i'm new on forgotten )

 

[johni]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

how can I edit accounts and stuff?

I'm wondering about the same


Nevermind! Figured it out

 

[vitoo]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

Thank u!

 

[foxfirediego]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

thanks dood

 

[Smog]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

Nice work!

 

[Xero]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

Great tutorial this helped me much with triggering, never understanded that good thanks.

 

[Isen]

RE: How to Setup a MySQL Database (Updated and Detailed Guide)

Finally a tutorial normal people can understand xD