Search the Community

Showing results for tags 'mysql'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Community
    • Announcements
    • Feedback
  • Metin2
    • General
    • Questions and Answers
    • Guides & HowTo
    • Design
    • Private Servers
    • Services
    • Videos
  • Releases
    • General
    • Tools
    • Programming / Scripts
    • Quests
    • Binaries & Clients/Serverfiles
    • 3D Models
    • 2D Graphics
    • Operating Systems
  • Safe Zone
    • Offtopic
    • Games Talk
    • Music/Videos/Art
  • D:\YMIR WORK\'s Topics

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



Website URL






Found 29 results

  1. Hi metin2dev community!sry 4 my eng.I stayed read only a lot of time but now i find unfixible(for me) problem,and I want you to show slove this.My vds provider update list of freebsd versions so i must go on 11.2/12 from 9.2.I dont find any install guide for it,and use Rumor's guide.but with it i only can up the 2089 files 2011,when i try to up smth neewst server(vps) go to down(on 9.2 work good)probably i do smth wrong.So Can anyone show me the guide for 11.2/12 bsd or help slove the problem.Maybe some psychic tell me slove when see my sysrr Succeed connecting.0220 14:51:00647 :: 0220 14:51:02065 :: HANDSHAKE RECV 237272 0 0220 14:51:02065 :: HANDSHAKE SEND 237272 0220 14:51:02182 :: HANDSHAKE RECV 237389 58 0220 14:51:02182 :: HANDSHAKE SEND 237505 0220 14:51:02512 :: KEY_AGREEMENT RECV 256 0220 14:51:02539 :: KEY_AGREEMENT SEND 256 0220 14:51:02594 :: KEY_AGREEMENT_COMPLETED RECV 0220 14:54:01289 :: HANDSHAKE RECV 416629 0 0220 14:54:01289 :: HANDSHAKE SEND 416629 0220 14:57:00529 :: HANDSHAKE RECV 595886 0 0220 14:57:00529 :: HANDSHAKE SEND 595886 0220 14:58:01991 :: ---------------------------------------------------------------------------- CLOSE LOGIN WINDOW 0220 14:58:01991 :: 0220 14:58:01991 :: ---------------------------------------------------------------------------- DELETE LOGIN WINDOW0220 14:58:01991 :: 0220 14:58:02008 :: ---------------------------------------------------------------------------- DELETE POPUP DIALOG 0220 14:58:02008 :: 0220 14:58:02008 :: ---------------------------------------------------------------------------- DELETE CURTAIN0220 14:58:02008 :: 0220 14:58:02008 :: ---------------------------------------------------------------------------- DELETE MAIN STREAM 0220 14:58:02008 :: 0220 14:58:02012 :: CResourceManager::__DestroyDeletingResourceMap 44 0220 14:58:02012 :: CResourceManager::__DestroyResourceMap 50 0220 14:58:02087 :: CResourceManager::__DestroyResourceMap 0 0220 14:58:02087 :: CPythonBackground Clear0220 14:58:02087 :: 0220 14:58:02087 :: PythonIME Clear0220 14:58:02087 :: 0220 14:58:02087 :: PythonNetworkMainStream Clear0220 14:58:02087 :: 0220 14:58:02087 :: Python Graphic Clear mysql.err
  2. In this topic I would like to teach you how to install MariaDB instead Oracle MySQL and why. Why prefer MariaDB instead MySQL? MariaDB it's a fork of MySQL and it is compatible with MySQL. Forecasts indicate that the MariaDB fork replace Oracle MySQL Server as rdbms. MariaDB have more features for performance and data integrity. One of this features is Aria storage engine. Aria is the upgrade of old MyISAM storage engine used on our Metin2 Private server. This old storage engine have some bugs and it isn't ACID like InnoDB. An upgrade of InnoDB is the fork XtraDB, used on MariaDB and Percona. So if you don't want/can't convert your metin2 tables from MyISAM to InnoDB or XtraDB (the best choice) you can use the similar storage engine: Aria. How to install MariaDB on FreeBSD. Administrate MariaDB it's like MySQL. The service is mysql-server and the path of MariaDB home directory is /var/db/mysql, like classical Oracle MySQL server. Remove old MySQL server installation. If you have mysql-server installed you need to deinstall it: Make a security's backup of your mysql data directory: cd /var/db && tar -cvJf mysql.tar.xz mysql Make a real backup of your applicative db (metin2, website etc.) with dump. You can use the CLI utility mysqldump or GUI with Navicat (right click on db name->Dump SQL file->Structure and data). Stop Mysql-server with: service mysql-server stop Remove mysql directory: rm -rf /var/db/mysql Find the mysql version: mysql --version Deinstall mysql from ports: cd /usr/ports/databases/mysqlxx-server && make deinstall clean && cd /usr/ports/databases/mysqlxx-client && make deinstall clean Where xx is the version find on previous step. Install MariaDB This thread was written when the lastest version of MariaDB was 10.1 update your ports tree: portsnap fetch update Install MariaDB: cd /usr/ports/databases/mariadb101-server && make install clean if not present, enable mysql service: echo "mysql_enable=YES" >> /etc/rc.conf start mysql server: service mysql-server start Import your application databases (metin2, website etc.) from dump. Do not import from datafile! If you use navicat, remember to create a new connection for MariaDB instead MySQL Convert MyISAM to new storage engine For better performance and security of your data you need to convert all of your table with a new storage engine. You can choose a different storage engine for each table. I suggest you to choose between Aria (new MyISAM) or XtraDB (new InnoDB). Choose Aria to read fastest and low write (example item_proto, mob_proto, shop, shop_item) or FULLTEXT index feature (to search fastest on text culomn). Choose XtraDB to critical table with hight write frequency (example player, item, account). To convert from one storage engine to another you have two ways: Via GUI like Navicat (one table at time). Right click on the table -> Design Table->Options->Engine. Change and save. Via query: ALTER TABLE <table_name> ENGINE=<engine>; This solution don't exclude the necessity of db backups. Please scedule frequently backup of your applicative dbs from dump. See mysqldump utility. For much safety, do also a datafile backup of entire mysql data directory (/var/db/mysql). It's for emergency restore of all mysql if dump import don't work. Use datafile restore only for whole mysql directory and only if there aren't another solution with dump.
  3. Hello community, I'vee been struggling all night long for a solution to this: I started a new VM and I installed mysql80-server and configured everything. But when the time came to extract my game's db in the folder, the service died! I couldn't get it back, not without deleting everything I extracted. Since then, I've tried everything, this service hates my tables. I tried manually creating and importing the data 1 by 1 in sql files, error all the time! I tried to import data from another connection and you 'll never guess! It says that '0000-00-00 00:00:00' cannot be set as default value of a datetime field. What do I have to do to get it working???
  4. Hello! I have a problem with turkish serverfiles. My mysql can't start! I have an error "mysqld got signal 11" >service mysql-server status >mysql is not running >service mysql-server start >mysql is starting >service mysql-server status >mysql is not running Ethost.err 181007 17:58:53 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 2018-10-07 17:58:53 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-10-07 17:58:53 5887 [Note] Plugin 'FEDERATED' is disabled. 2018-10-07 17:58:53 5887 [Note] InnoDB: The InnoDB memory heap is disabled 2018-10-07 17:58:53 5887 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-10-07 17:58:53 5887 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-10-07 17:58:53 5887 [Note] InnoDB: Not using CPU crc32 instructions 2018-10-07 17:58:53 5887 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2018-10-07 17:58:53 5887 [Note] InnoDB: Completed initialization of buffer pool 2018-10-07 17:58:53 5887 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created! 2018-10-07 17:58:53 5887 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB 2018-10-07 17:58:53 5887 [Note] InnoDB: Database physically writes the file full: wait... 2018-10-07 17:58:53 5887 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB 2018-10-07 17:58:53 5887 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB 2018-10-07 17:58:54 5887 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2018-10-07 17:58:54 5887 [Warning] InnoDB: New log files created, LSN=45781 2018-10-07 17:58:54 5887 [Note] InnoDB: Doublewrite buffer not found: creating new 2018-10-07 17:58:54 5887 [Note] InnoDB: Doublewrite buffer created 2018-10-07 17:58:54 5887 [Note] InnoDB: 128 rollback segment(s) are active. 2018-10-07 17:58:54 5887 [Warning] InnoDB: Creating foreign key constraint system tables. 2018-10-07 17:58:54 5887 [Note] InnoDB: Foreign key constraint system tables created 2018-10-07 17:58:54 5887 [Note] InnoDB: Creating tablespace and datafile system tables. 2018-10-07 17:58:54 5887 [Note] InnoDB: Tablespace and datafile system tables created. 2018-10-07 17:58:54 5887 [Note] InnoDB: Waiting for purge to start 2018-10-07 17:58:54 5887 [Note] InnoDB: 5.6.14 started; log sequence number 0 2018-10-07 17:58:54 5887 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: e40e91a9-ca49-11e8-849d-080027db0e05. 2018-10-07 17:58:54 5887 [Note] Server hostname (bind-address): '*'; port: 3306 2018-10-07 17:58:54 5887 [Note] IPv6 is available. 2018-10-07 17:58:54 5887 [Note] - '::' resolves to '::'; 2018-10-07 17:58:54 5887 [Note] Server socket created on IP: '::'. 15:58:54 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=0 max_threads=151 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 67551 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Anyone knows how to fix this? Thank u for all answers! Greetings!
  5. Denny2399

    open Mariadb install problem

    Hello guys, I have recently installed mariadb and mysql5.6 on my Freebsd and it merged(don't ask why I did this), then I couldn't start mysql again. I deleted every pkg about mysql, but when I try to install mariadb100-server again then I got error. Anyone who could help?
  6. Mind Rapist

    MySQL is sooo 2010's

    Hello community. I've been away for a while... But today I came up with an idea: did you ever think of changing your database protocol? I mean MySQL is convenient for everyone as all of us got used to it over the years. But is it still out best solutions in 2017? This post is about (hopefully) inspiring a great developer for tutorials on how to change MySQL protocols to MS SQL (2016), PostgreSQL, MongoDB or even Cassandra if possible directly from the source. Think about the speed your server could gain from Mongo or how much more smoothly can the massive amount of db requests in international servers be with Cassandra. I don't know about you guys but I think it's time for a system upgrade. I hope I inspired some of you
  7. Hello, I am trying to add new items to item_proto in MySQL using QUERY. When I start Query, it says: "1062 - Duplicate entry '5137' for key 'PRIMARY'". But there is not item with vnum 5137, the last vnum is 5136 (like on screen) item_proto: items (query): Could you help me please? Thank you very much! RN
  8. Kroneees


    JsonToMobProto View File Hello everyone, today I want to show you my program that converts data from json(Export from mysql) in mob proto.txt public static string[] arRank = { "PAWN", "S_PAWN", "KNIGHT", "S_KNIGHT", "BOSS", "KING" }; public static string[] arType = { "MONSTER", "NPC", "STONE", "WARP", "DOOR", "BUILDING", "PC", "POLYMORPH_PC", "HORSE", "GOTO" }; public static string[] arBattleType = { "MELEE", "RANGE", "MAGIC", "SPECIAL", "POWER", "TANKER", "SUPER_POWER", "SUPER_TANKER" }; public static string[] header_mob_proto = { "VNUM", "NAME", "RANK", "TYPE", "BATTLE_TYPE", "LEVEL", "AI_FLAG", "MOUNT_CAPACITY", "RACE_FLAG", "IMMUNE_FLAG", "EMPIRE", "FOLDER", "ON_CLICK", "ST", "DX", "HT", "IQ", "DAMAGE_MIN", "DAMAGE_MAX", "MAX_HP", "REGEN_CYCLE", "REGEN_PERCENT", "GOLD_MIN", "GOLD_MAX", "EXP", "DEF", "ATTACK_SPEED", "MOVE_SPEED", "AGGRESSIVE_HP_PCT", "AGGRESSIVE_SIGHT", "ATTACK_RANGE", "DROP_ITEM", "RESURRECTION_VNUM", "ENCHANT_CURSE", "ENCHANT_SLOW", "ENCHANT_POISON", "ENCHANT_STUN", "ENCHANT_CRITICAL", "ENCHANT_PENETRATE", "RESIST_SWORD", "RESIST_TWOHAND", "RESIST_DAGGER", "RESIST_BELL", "RESIST_FAN", "RESIST_BOW", "RESIST_CLAW", "RESIST_FIRE", "RESIST_ELECT", "RESIST_MAGIC", "RESIST_WIND", "RESIST_POISON", "DAM_MULTIPLY", "SUMMON", "DRAIN_SP", "MOB_COLOR", "POLYMORPH_ITEM", "SKILL_LEVEL0", "SKILL_VNUM0", "SKILL_LEVEL1", "SKILL_VNUM1", "SKILL_LEVEL2", "SKILL_VNUM2", "SKILL_LEVEL3", "SKILL_VNUM3", "SKILL_LEVEL4", "SKILL_VNUM4", "SP_BERSERK", "SP_STONESKIN", "SP_GODSPEED", "SP_DEATHBLOW", "SP_REVIVE", "SKILL_RANGE" }; Write to me in PM if you need a special version for you, or if you found a bug. Maybe later I'll post the source code of the application. Submitter Kroneees Submitted 04/17/2017 Category Tools
  9. Hey there, i dont know, how it happened, but about 2 weeks ago, someone hacked my mysql database, encrypted alle datas and in case I pay 0,5 Bitcoins, they will decrypt my files and give it back to me, so that my mysql works anymore. I checked the IP's, that was an IP from China, so I thought maybe chinese hackers. After that, I restarted my root-server on default settings. I changed password and the password is really hard to hack! The hacked mysql IP stay the same, I just changed password. I set up mysql again and the server worked great for about a week. One day I logged in, all my players were deleted or there wasnt an existing player directory in my mysqsl anymore. So either someone deleted them or the was some issues caused by the hoster, but in fact there was no player directory anymore, I dont know how this could be happen. Serverfiles are version of 2013. So is there a hacking possibility caused by these old files, that I havent fixxed until yet or what can me the cause of my problem? Would be nice, if anyone has an answer for that
  10. hello guys, first, sorry for my bad english. So, i have a problem with navicat/mysql. everytime if i try to connect with navicat to my server i get this msg: I resetted my root, install all new and its change nothing. I get everytime the same error. DB Syserr: Mar 17 18:42:42 :: LOCALE set to latin1 SYSERR: Mar 17 18:42:42 :: Start: TABLE_POSTFIX not configured use default Mar 17 18:42:42 :: connecting to MySQL server (player) Mar 17 18:42:42 :: CREATING DIRECT_SQL Mar 17 18:42:42 :: AsyncSQL: locale latin1 Mar 17 18:42:42 :: failed, retrying in 5 seconds Mar 17 18:42:47 :: CREATING DIRECT_SQL Mar 17 18:42:47 :: AsyncSQL: locale latin1 Mar 17 18:42:47 :: failed, retrying in 5 seconds Mar 17 18:42:52 :: CREATING DIRECT_SQL Mar 17 18:42:52 :: AsyncSQL: locale latin1 Mar 17 18:42:52 :: failed, retrying in 5 seconds Mar 17 18:42:57 :: CREATING DIRECT_SQL Mar 17 18:42:57 :: AsyncSQL: locale latin1 Mar 17 18:42:57 :: failed, retrying in 5 seconds Mar 17 18:43:02 :: CREATING DIRECT_SQL Mar 17 18:43:02 :: AsyncSQL: locale latin1 Mar 17 18:43:02 :: failed, retrying in 5 seconds Putty Error: mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) The mistake came all of a sudden. Previously I could connect without problems. I did not change anything except a quest. Please help me.
  11. SYSERR: Mar 8 01:33:18 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'setRaceFlag' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (701, "?????", "Fanatic Intunecat", 0, who cand help me to fix it?I search on all forum but i don't find a solution.
  12. Hi guys i am installing my metin2 server on freebsd but when i uploaded new mysql file from serverfiles it show this error any help please? mysql version is 5.7 Thank you for every help. <3
  13. RaVenRG

    Server install

    Hi guys, I am trying to make my own server on VPS freebsd well what did i did. I need to make new navicat user so i do mysql -u root -p But it says mysql.sock error idk why any helps? i cant continue with installing without this step please. Thanks I am making server with this tutorial PART1 PART 2
  14. icewolf

    7&8 Skill Mysql problem

    Hi i'm adding the mysql part of 7&8 skill system but when i try to click Run i had some problem with it this is my 7&8 skill Mysql
  15. Hello, I try to delete an item from inventory of a player. Problem it's tie for commit of source. How can commit manually in php. My code: $player->beginTransaction(); $stmt = $player->prepare("DELETE FROM item WHERE owner_id=?"); $stmt->bindParam(1, $id, PDO::PARAM_INT); $stmt->execute(); $player->commit();
  16. xavier1400

    Mysql Account to txt

    Hello guys I want to know how I put account files to txt to see all accounts, how can I do it ?
  17. likeabeast

    Crea_Item error

    Hello, Tree days trying to fix this error in mysql .. i configured the crea_item script RIGHT , with all correct data , and still error , i allowed ROOT login , changed root password , tried with another user , but still not working , what should i do? , btw is not because of webhost , i'm sure! Maybe there is another way to create a modded item , Quest , or something..
  18. gummyantifi

    Mysql SELECT

    $mysqlquery = "SELECT id, login, availDt, status FROM account WHERE status='".userinfo(status)."'"; That comes out to me all the accounts with the "OK" How to set ignor "AvailDt" To value 0000-00-00 0:00:00 Ignoring from writing?
  19. This warning only show up with mysql version 5.6 & 5.7. If you have a lower version please ignore this post. Warning on shell & mysql log: Using a password on the command line interface can be insecure. I know a lot of people use the mysql_query (standard) function from questlib.lua and they get this warning. If you use a mysql user change the above "YOURUSERNAME" and use the command: mysql_config_editor set --login-path=local --host=localhost --user=YOURUSERNAME --password If you use the root mysql user, use the command: mysql_config_editor set --login-path=local --host=localhost --user=root --password Put your password. OK We can see, the system creates a new crypted file: .mylogin.cnf You can see this file on /home/YOURUSERNAME/.mylogin.cnf or for root: /root/.mylogin.cnf Is crypted but you can see what's inside (password is hidden by *****) with the command: mysql_config_editor print --all If you want to enter mysql just use the command: mysql --login-path=local Now .. lets open questlib.lua and remove the mysql_query function and add this new one .. because is not need to read anymore what's inside of CONFIG file (username/password). mysql_query = function(query) math.randomseed(os.time()) local fi,t,out = 'mysql_data_'..math.random(10^9)+math.random(2^4,2^10),{},{} os.execute('mysql --login-path=local -e'..string.format('%q',query)..' > ' for av in,'r'):lines() do table.insert(t,split(av,'\t')) end; os.remove(fi); for i = 2, table.getn(t) do table.foreach(t,function(a,b) out[i-1] = out[i-1] or {} out[i-1][a] = tonumber(b) or b or 'NULL' out[t[1][a]] = out[t[1][a]] or {} out[t[1][a]][i-1] = tonumber(b) or b or 'NULL' end) end out.__lines = t[1] return out end That is all. Have a nice day!
  20. dako12

    Mysql EXPLOIT

    Hello Recently I 've seen many server got their databases deleted.. This is caused from their sites? or from the new gamefile? If I block mysql port and connect through ssh and create an account for homepage only to write new accounts will I be protected?
  21. Hi, im testing the code mysql_direct_query but i have problem with the table, here the problem: With mysql_query normal: With direct_mysql_query: and say that error: is too strange because i can insert, remove or getn from the table without errors but this not working.. can any try to fix that? thanks for read!
  22. Hi! I am trying to make a VDI, but I can't install the MySQL. I have tried to input those commands but when it tries to fetch it says -> No Address Record cd /usr/ports/databases/mysql56-servermake WITH_XCHARSET=all install cleanError: And I cannot connect with putty/FileZilla Error: Any idea whats wrong?
  23. iPeri

    [RLS]Regen Creator by iPeri

    Hi Community of Metin2Dev, i want to release my regen.txt creator tool for in game creation, join your server, install the tool with the npc 9010 and go around the map with using item 30181. The regen you can see in the database table regen Have much fun with my little ingame tool ! Link for download: your iPeri
  24. RoThe

    MySQL Hasher

    Hey guys, since i needed a few MySQL Hashes in the last few days i wrote a little tool to convert normal text to a MySQL5 hash. I'd thought I'd share it, maybe you can need it. You should need it for account passwords since those are hashed. Just start the program, type in your password/text to hash, click the button and it will be hashed and also copied to your clipboard. You just need to paste it then. Virustotal: Download: RoThes MySQL5 Hasher.exe
  25. Hello I took one server of companies you have installed the files and when you play the game gets an error in the data rules Is it possible to install the Mysql-55 way system: FreeBSD 9.3 64Bit