u are still using database. just that those YML files are used rather than using sql.
Well u can convert if needed have tools to convert yml -> sql if u want updated one since rathena didnt automatically update that for a quite long time.
u change something in config ? such as use sql = yes ?
// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)
use_sql_db: no
above is the default one. should be 'no'.
Just incase u changed that.
u can see atcommands at docs. there are some commands such as reloadbattleconf, reloadmobdb, reloaditemdb and some more.
also unloadnpcfile and loadnpc
recompile only needed when u edit src folder.
yes thats what you should do. dont alter the main.sql
But since you already know, where the reason it didnt work, no problem to change the credential for server.
then why your main.sql is different with what should be in latest rathena ?
Its really different. I dont know since when rathena using that 'M' data and that ID as insert into.
Im pretty sure its not from latest rathena.
u should check your conf/inter-athena.conf too make sure the sql connection is correct.
and what rathena file is this ? why doesnt have sql for server account ?
Better use latest rathena folder from the git.
yes because GRF Editor can change the encoding automatically but I dont know how did u change the files inside GRF. Some software cant detect and automatically changed to correct encoding.