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

[Cm Himen]

Error

SQL query:

INSERT INTO `accounts`
VALUES ( 1, '1', 1, 65535, 0, '0', '', 0, 0 ) ;

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1




i dont have a account folder or players folder do i need that im using forgotten server

 

[Schnap]

Error

SQL query:

INSERT INTO `accounts`
VALUES ( 1, '1', 1, 65535, 0, '0', '', 0, 0 ) ;

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1




i dont have a account folder or players folder do i need that im using forgotten server

same problem

 

[SupremuS]

~^looooooooooooooool ^^^^^^^^

Error

SQL query:

INSERT INTO `accounts`
VALUES ( 1, '1', 1, 65535, 0, '0', '', 0, 0 ) ;

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

SAME ERROR...

CAN PLS ANYBODY HELP US OUT!??!?!
OR YOU ARE TOO VALUABLE NOT TO LOSE TIME HELPING "NOOBS"

Appreciated
Supremus

 

[Wrathe]

Great tutorial

 

[Saphira]

Error

SQL query:

CREATE TABLE `player_deaths` (
`player_id` INT NOT NULL ,
`time` BIGINT UNSIGNED NOT NULL DEFAULT 0,
`level` INT NOT NULL DEFAULT 1,
`killed_by` VARCHAR( 255 ) NOT NULL ,
`is_player` TINYINT( 1 ) NOT NULL DEFAULT 1,
FOREIGN KEY ( `player_id` ) REFERENCES `players` ( `id` ) ON DELETE CASCADE
) ENGINE = InnoDB;

MySQL said: Documentation
#1050 - Table 'player_deaths' already exists

I uploaded the SQL file in the TFS folder...
I tried to use the new phpadmin... and this happend! 0.o

//Saphira

 

[fokuleh]

SQL query failed when i trying to make a new account!!! HELP!

 

[sm2000]

I get this error message when i'm trying to import files!

SQL-query:

INSERT INTO `accounts`
VALUES ( 1, '1', 1, 65535, 0, '0', '', 0, 0 ) ;

MySQL said: Dokumentation
#1136 - Column count doesn't match value count at row 1

 

[Johnny Zoo]

Xampp error

Well, I always used xampp but now I needed to update it (so I have PhpMyAdmin 2.11).

So I downloaded Xampp 1.6.4 but I can't run xampp-start.exe

I never had this problem with the previous xampp...

It looks like this when I run xampp-start.exe

After this appeared, the screen just closes...


I hope you can help me.

 

[clone]

Windows users type: pathToMySQL -u yourUserName yourDatabaseName -p < triggers.sql
Example: C:/pathtomysql -u root theforgottenserver -p < triggers.sql


I dont get that part.

 

[Xanix]

uhm, wtf it dident work :S got error :O

 

[Jonern]

Well, I always used xampp but now I needed to update it (so I have PhpMyAdmin 2.11).

So I downloaded Xampp 1.6.4 but I can't run xampp-start.exe

I never had this problem with the previous xampp...

It looks like this when I run xampp-start.exe

After this appeared, the screen just closes...


I hope you can help me.

Looks like to me that apache is already running. Check in task manager.

Windows users type: pathToMySQL -u yourUserName yourDatabaseName -p < triggers.sql
Example: C:/pathtomysql -u root theforgottenserver -p < triggers.sql


I dont get that part.

If you've added mysql.exe in windows PATH (option when installing. Just open CMD and type mysql and see if you get any mysql errors) you put theforgottenserver.sql in C:/ and in CMD you type in this order:

C:\Documents and settings\user>[COLOR=Red]C:[/COLOR]
C:\>[COLOR=Red]mysql -u root -p < theforgottenserver.sql[/COLOR]
Enter password: [COLOR=Red]********[/COLOR]

What you see in black is what it will say before you write anything, the red part is what you should copy in.

If you dont have mysql in PATH then do this first before you do the first step:
Lets say you got mysql.exe here: C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql.exe
Open CMD and write:

C:\Documents and settings\user>[COLOR=Red]C:
[COLOR=Black]C:\>[COLOR=Red]cd prog*\mysql\m*\bi*
[/COLOR][/COLOR][/COLOR][COLOR=Red][COLOR=Black]C:\Program Files\MySQL\MySQL Server 5.0\bin>[/COLOR][/COLOR][COLOR=Red]mysql -u root -p < theforgottenserver.sql[/COLOR]
Enter password: [COLOR=Red]********[/COLOR]

Again, copy the red. I'm using * as short and it works in CMD. Just remember to place theforgottenserver.sql at the same place you got MySQL if you do it this way.

 

[Johnny Zoo]

Nvm

I use again Xampp 1.6.2 =)

 

[Ryu]

link dont work
o http://localhost/xampp

 

[Jonern]

You haven't started xampp (apache)

 

[Ryu]

I dont understand how to put triggers.. can someone explain me plz... I dont find the file so I have to creat a new one, so I create a new sql file or a a new word document or which. and then I insert the info and then what... I dont get it

 

[Jonern]

Have you read MYSQL-HELP ?

 

[Ryu]

yes i read it but it does not explain triggers

 

[Delirium]

yes i read it but it does not explain triggers

If you use the latest phpMyAdmin you can use triggers

 

[Beguv]

how do i replace phpadmin with a newer version? i have version 2.7 now and the cmd thing does not work for me i get the same error 1064
i copied phpadmin 2.13 over my old php admin but then i cant login anymore
neither have the xampp layout

greetings , beguv

 

[NeL]

There is no forgottenserver.sql on the newest one, I am getting mad with that .s3db file, dunno how it's used