Jump to content
  • 0

Import problems


Xano

Question


  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  30
  • Reputation:   0
  • Joined:  07/23/13
  • Last Seen:  

Hi,

 

today I have problems with my database. >.<

I've just finished my mob_db2 and mob_skill_db2 enteries and then I tried to import them but it didn't work.

 

For my mob_db2 and skill_db2 I use this path: trunk/db/...

 

I want to import these both files into my SQL Database with copying them into the import folder (path: trunk/db/import...)

After this I started my server again and the copied files with the mobs wasn't added to the database.

 

My inter_athena.conf looks like this:

// Athena InterServer configuration.
// Contains settings shared/used by more than 1 server.

// Options for both versions

// Log Inter Connections, etc.?
log_inter: 1

// Inter Log Filename
inter_log_filename: log/inter.log

// Level range for sharing within a party
party_share_level: 50

// SQL version options only

// You can specify the codepage to use in your mySQL tables here.
// (Note that this feature requires MySQL 4.1+)
//default_codepage: 


// For IPs, ideally under linux, you want to use localhost instead of 127.0.0.1 
// Under windows, you want to use 127.0.0.1.  If you see a message like
// "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)"
// and you have localhost, switch it to 127.0.0.1

// Global SQL settings
// overridden by local settings when the hostname is defined there
// (currently only the login-server reads/obeys these settings)
sql.db_hostname: CENSORED
sql.db_port: CENSORED
sql.db_username: CENSORED
sql.db_password: CENSORED
sql.db_database: CENSORED
sql.codepage:

// MySQL Character SQL CENSORED
char_server_ip: CENSORED
char_server_port: CENSORED
char_server_id: CENSORED
char_server_pw: CENSORED
char_server_db: CENSORED

// MySQL Map SQL Server
map_server_ip: CENSORED
map_server_port: CENSORED
map_server_id: CENSORED
map_server_pw: CENSORED
map_server_db: CENSORED

// MySQL Log SQL Database
log_db_ip: CENSORED
log_db_port: CENSORED
log_db_id: CENSORED
log_db_pw: CENSORED
log_db_db: CENSORED
log_codepage:
log_login_db: CENSORED

// MySQL Reconnect Settings
// - mysql_reconnect_type:
//   1: When MySQL disconnects during runtime, the server tries to reconnect
//      mysql_reconnect_count times and shuts down if unsuccessful.
//   2: When mysql disconnects during runtime, it tries to reconnect indefinitely.
mysql_reconnect_type: 2
mysql_reconnect_count: 1

// DO NOT CHANGE ANYTHING BEYOND THIS LINE UNLESS YOU KNOW YOUR DATABASE DAMN WELL
// this is meant for people who KNOW their stuff, and for some reason want to change their
// database layout. [CLOWNISIUS]

// ALL MySQL Database Table names

// Char Database Tables
char_db: char
hotkey_db: hotkey
scdata_db: sc_data
cart_db: cart_inventory
inventory_db: inventory
charlog_db: charlog
storage_db: storage
reg_db: global_reg_value
skill_db: skill
interlog_db: interlog
memo_db: memo
guild_db: guild
guild_alliance_db: guild_alliance
guild_castle_db: guild_castle
guild_expulsion_db: guild_expulsion
guild_member_db: guild_member
guild_skill_db: guild_skill
guild_position_db: guild_position
guild_storage_db: guild_storage
party_db: party
pet_db: pet
friend_db: friends
mail_db: mail
auction_db: auction
quest_db: quest
homunculus_db: homunculus
skill_homunculus_db: skill_homunculus
mercenary_db: mercenary
mercenary_owner_db: mercenary_owner
elemental_db: elemental
ragsrvinfo_db: ragsrvinfo
skillcooldown_db: skillcooldown
bonus_script_db: bonus_script

// Map Database Tables
buyingstore_db: buyingstores
buyingstore_items_db: buyingstore_items
item_db_db: item_db
//item_db_re_db: item_db_re
item_db2_db: item_db2
//item_db2_db: item_db2_re
item_cash_db_db: item_cash_db
item_cash_db2_db: item_cash_db2
mob_db_db: mob_db
//mob_db_re_db: mob_db_re
mob_db2_db: mob_db2
//mob_db2_db: mob_db2_re
//mob_skill_db_db: mob_skill_db
//mob_skill_db_re_db: mob_skill_db_re
mob_skill_db2_db: mob_skill_db2
//mob_skill_db2_db: mob_skill_db2_re
mapreg_db: mapreg
vending_db: vendings
vending_items_db: vending_items

// Use SQL item_db, mob_db and mob_skill_db for the map server? (yes/no)
use_sql_db: yes

import: conf/import/inter_conf.txt

 

I hope that you can help me...

 

 

Thanks in advance ~

Edited by Xano
Link to comment
Share on other sites

2 answers to this question

Recommended Posts


  • Group:  Members
  • Topic Count:  16
  • Topics Per Day:  0.00
  • Content Count:  737
  • Reputation:   216
  • Joined:  11/29/11
  • Last Seen:  

db/import/ is using csv format, just like db/re/*.txt

If you plan to use sql table you need to import them into your schema yourself

Link to comment
Share on other sites


  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  30
  • Reputation:   0
  • Joined:  07/23/13
  • Last Seen:  

http://rathena.org/wiki/Import_folder

 

Maybe I've understand something wrong.

Okay I won't import the files into SQL anymore ... So how can I run the mob and skill db2 as a .txt ?

The item_db and mob_db2 should run on SQL because of some scripts.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...