Solved Problem with importing mysql!

[The Tank]

Not sure what prefix to use, but here is my problem. Somewhere in this mess of information and error below I am doing something wrong. My apologies, I'm not used to forum "tools" and what not, So if anything isn't correct.. my bad..


Trying to follow this step,

"After all of that is done, go back to.. "localhost/phpmyadmin" and set up a database. You should find a place to create a database on the home page, enter the server name you put up in the config.lua above this, and click enter. After that, click on the "Import" tab and then click "Browse" search for the "forgottenserver.sql" in your server directory, click on that, then click "go"."
-----------
I get an error from trying to set up a database with the phpmyadmin site, if i try to continue to use the "import" button and select "mysql" in the "schemas" file I get more errors.
If someone could let me know what I am doing wrong or give me a small tutorial on how to fix this.. would be greatly appreciated! If more information is needed let me know!

-----------
Error

SQL query:

DROP TRIGGER IF EXISTS `oncreate_players` ;

MySQL said: Documentation
#1046 - No database selected
-----------
13.1.30. DROP TRIGGER Syntax

DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name

This statement drops a trigger. The schema (database) name is optional. If the schema is omitted, the trigger is dropped from the default schema. DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger.

Use IF EXISTS to prevent an error from occurring for a trigger that does not exist. A NOTE is generated for a nonexistent trigger when using IF EXISTS. See Section 13.7.5.41, “SHOW WARNINGS Syntax”.

Triggers for a table are also dropped if you drop the table.

 

[sn3ejk]

#1046 - No database selected

You must select a databaseon which all commands to be executed.

 

[The Tank]

You must select a databaseon which all commands to be executed.

What would the database file be named? I've tried several different files, I'm simply lost right now so would be helpful if you could walk me through it.

 

[Milice]

if you have XAMPP installed just go to http://127.0.0.1/phpmyadmin and create a new database.

 

[The Tank]

if you have XAMPP installed just go to http://127.0.0.1/phpmyadmin and create a new database.

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "hidden"
sqlDatabase = "mysql"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "plain"

This is my info, what do I put in "create database name" box?

Edit: or what needs to be changed?

 

[TGYoshi]

sqlDatabase = "mysql"

You've set there that mysql is your database name, kinda weird name I'd say
I'd change it to

sqlDatabase = "ot"

and create a database named ot .

 

[The Tank]

I got it!! Thank you everyone! Messed up first database, then changed my "sqldatabase name" but didn't save, then it all became a mess but i did get it working now. Thanks again for your help/support.