Windows MySQL database error

[Magiciano]

Been trying to get past this for some time now but I can't figure it out.
I'm getting an error, probably my mistake...

This is my config.lua file:

As you can see I already deleted the comment lines.

This is how my otserv folder looks like:

Any idea how to fix this?

 

[Kavvson]

I assume your database name in phpmyadmin is not forgottenserver.s3db - its a file ( sqlDatabasename = "Name of DB here" )

 

[Magiciano]

Thanks a lot, rep +!
I named my database file to "tfs.s3db", created a user and database in phpmyadmin with the name "tfs.s3db". This solved the problem.
A new one popped up:

 

[Debian]

now you have to search in the schema folder
the mysql.sql file and import into your current database

 

[Magiciano]

now you have to search in the schema folder
the mysql.sql file and import into your current database

Alright, sorry for all the trouble - doing that gives this error in phpmyadmin:

SQL query:

CREATE TABLE `house_auctions` (
`house_id` INT UNSIGNED NOT NULL ,
`world_id` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT 0,
`player_id` INT NOT NULL ,
`bid` INT UNSIGNED NOT NULL DEFAULT 0,
`limit` INT UNSIGNED NOT NULL DEFAULT 0,
`endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
UNIQUE (
`house_id` ,
`world_id`
),
FOREIGN KEY ( `house_id` , `world_id` ) REFERENCES `houses` ( `id` , `world_id` ) ON DELETE CASCADE ,
FOREIGN KEY ( `player_id` ) REFERENCES `players` ( `id` ) ON DELETE CASCADE
) ENGINE = InnoDB;

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

 

[Nefs]

You have already the table house_auctions, delete your table house_auctions or import all tables without house_auctions xD

 

[Magiciano]

You have already the table house_auctions, delete your table house_auctions or import all tables without house_auctions xD

Ok did that succesfully but the older error in still exists:

 

[velcis]

Magiciano you need to copy mysql.sql from schema folder, and go to your webserver like and look the folder : MySQL > Bin ".

Paste mysql.sql in Bin folder.

Now open a Dos Windows, go to Run menu and write "CMD".

Then, write this : "cd PATHTOYOURWEBSERVER "
Example: (C:/Program Files/VertrigoServ/Mysql/Bin).

Then, you need to write: " mysql -u USER DATABASE -p < mysql.sql " without quotes., and change the USER for the user like "ROOT"and DATABASE the name or database
Then appears a line with Password: insert your password of root or your user, press Enter, and the dabase will be imported successfully.



OBS: Dont import it directly in PhPMyAdmin cause it dont import the Triggers.

 

[Magiciano]

Solved thanks all!