SQL FILE?

[imback1]

hello
i'm trying to use phpmyadmin but when i browse the sql file, i couldn't find it on my server folder but i used sqiltebrowser and its working good with forgottenserver.s3db and when i browse this file on phpmyadmin i found this

if this isnt the file ,so how this is working with sqiltebrowser ? and where is file of sql of my server?
i used this on sometimes but didnt work only appeared my files like accounts/players etc but i didn't find anything on it ,only account manager

 

[dominique120]

use the mysql file inside of the schemas folder.

 

[imback1]

use the mysql file inside of the schemas folder.

i already said to you i used it before but i didnt find my database on it only found my queries not my data :S

 

[imback1]

BUMP?!?!?!?!??!

 

[Limos]

What is the problem?

 

[Ignazio]

Tbh, that is a really bad database, whitespace and dot. In any case, make sure you have written in the database name in the config.lua file in your root OT folder.

Ignazio

 

[EvilSkillz]

nope
He used sqlite before and created his account in sqlite so he will never find them in sql lol it's new database

 

[imback1]

nope
He used sqlite before and created his account in sqlite so he will never find them in sql lol it's new database

Tbh, that is a really bad database, whitespace and dot. In any case, make sure you have written in the database name in the config.lua file in your root OT folder.

Ignazio

What is the problem?

i can't find my database btw i wrote mysql on database name and still nothing :S mmm if you have a time may you come on my TV and try to find what is wrong with it?

 

[Ignazio]

Do you get errors in the console? Show them.

Show the database part in your config lua file as well.

Ignazio

 

[Limos]

If you created an account in SQLite it won't be there in MySQL, so you have to create a new account.

 

[imback1]

couldn't establish connection to sql database

Do you get errors in the console? Show them.

Show the database part in your config lua file as well.

Ignazio

If you created an account in SQLite it won't be there in MySQL, so you have to create a new account.

sqlType = "sqlite"

 

[Limos]

You follow this tutorial to see if you did the MySQL part correct
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

Post the full error.

Change the type to mysql

 

[imback1]

You follow this tutorial to see if you did the MySQL part correct
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

Post the full error.

Change the type to mysql

 

[Ignazio]

Your database name must correspond to the one you use in your mysql

sqlType = "mysql"
sqlPass = "whateverisyourpassword"
sqlDatabase = "forgotten 8.60"

Ignazio

 

[Ray Rewind]

You should get notepad++ first before editing anything with notepad

 

[imback1]

You should get notepad++ first before editing anything with notepad

already got it :d but its was mistake

Your database name must correspond to the one you use in your mysql

sqlType = "mysql"
sqlPass = "whateverisyourpassword"
sqlDatabase = "forgotten 8.60"

Ignazio

[12/12/2014 18:01:23] Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on 'localhost' (10061) (2003)
btw how can i make sql pass?

 

[Limos]

Change localhost to 127.0.0.1

 

[imback1]

Change localhost to 127.0.0.1

[12/12/2014 18:08:58] Failed connecting to database - MYSQL ERROR: Can't connect to MySQL server on '127.0.0.1' (10061) (2003)
mmm is phpmyadmin more important than sqlitebrowser?

 

[Limos]

It's a different database type, 1 is MySQL, other is SQLite.
You can also use SQLite is you have a small amount of players, then you don't need to setup anything.

If you want to use MySQL, try to do it exactly like in this tutorial, follow it step by step and do the config.lua part like in this tutorial.
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

 

[imback1]

It's a different database type, 1 is MySQL, other is SQLite.
Try to do it exactly like in this tutorial, follow it step by step and do the config.lua part like in this tutorial.
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

okey i'll watch it
thx