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

[yoyoyoyo]

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

i set it up but get an error
FATAL: Could not open the map stream

 

[Transvans]

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

THANKS THIS REALLY HELPs

 

[Fiko]

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

The only thing i can say about this is : WTF!?

UHajajajajajjaa

Nice tutorial

 

[liltangruler]

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

G:xamppxamppmysql>G:xamppxamppmysqlbinmysql.exe -u root ellisiaots -p <t
riggers.sql
Enter password: ******
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'IF EXISTS `oncreate_players`' at line 1

how do i fix this problem?

 

[lucasbro]

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

Thanks man, i need this tutorial

 

[Delirium]

G:xamppxamppmysql>G:xamppxamppmysqlbinmysql.exe -u root ellisiaots -p <t
riggers.sql
Enter password: ******
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear 'IF EXISTS `oncreate_players`' at line 1

how do i fix this problem?

xamppxamppmysq? wtf!?

G:xamppxamppmysq? wtf!?

you need to locate mysql.exe like this c:\xampp\mysql\bin\mysql.exe

 

[Skeddar]

After I imported the forgottenserver.sql this happened to me:

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: 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 'DELIMITER |

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

What should I do?

 

[alkamenes]

Thanks for the tut. It should be useful

 

[Jiraiya]

Great tutorial just great

 

[Delirium]

After I imported the forgottenserver.sql this happened to me:



What should I do?

Use phpmyadmin v2.11 @ http://www.phpmyadmin.net

 

[Skeddar]

I've downloaded it..
Where do I put it?
install the xampp and just replace the phpmyadmin folders?

--Edit--
Ok figured it out
It seems to be working, but I still can't find a way to change stuff and see the accounts, etc.
How can I do it?

--Edit2--

Nevermind just got how this thing works
thanks anyway
finally got to understand something about sql =D

 

[xTremoxx]

ty man i needed it..

 

[GoD vrastus]

THIS IS GREAT I DIDNT KNOW , I DOWNLOAD SQL THINKING THAT IT WAS LIKE XML i think it helped a lot of people
=D

 

[gunzino]

Usefull, thanks.

 

[Delirium]

Omggg this need progamn?

yes,is that bad?

THIS IS GREAT I DIDNT KNOW , I DOWNLOAD SQL THINKING THAT IT WAS LIKE XML i think it helped a lot of people
=D

Is your Caps lock button bugged?

 

[BrasseN]

lol, my error again.
When i tried upload the forgottenserver.sql to the database, 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

 

[Delirium]

Use phpmyadmin v2.11 or read the second part of tutorial(man are you blind?)

 

[klulukasz]

"MySQL Query Browser" is nice mysql console too. but rather for more advanced users

 

[alucardj]

cool

thx for this post

 

[reevesy]

what directory do i save the triggers file in?

C:\Server\xampp\mysql -u root theforgottenserver -p < triggers.sql
this doesnt work :S comes up the system cant find the file specified.

also what folder do i put the triggers file in?

ok done it all but chars still dont save :S please help.