DeYaN. 29 Posted August 16, 2016 Share Posted August 16, 2016 (edited) Hello everyone , i have a simple question , who can i find this position,line in navicat ? My item tabble is crashed at 2-3 days , again , again and again with this error. Edited August 24, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Premium imWelly 26 Posted August 16, 2016 Premium Share Posted August 16, 2016 i had this error before my problem was there is no enough space for mysql in that path i fixed it by moving mysql to new path which is /home thats how i fixed it once and for all Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted August 16, 2016 Author Share Posted August 16, 2016 51 minutes ago, blw said: i had this error before my problem was there is no enough space for mysql in that path i fixed it by moving mysql to new path which is /home thats how i fixed it once and for all so , you are move the mysql from /var/db/ in ex : /usr/home/db ? and that`s all, ? fix ? Link to comment Share on other sites More sharing options...
MichaelM 40 Posted August 16, 2016 Share Posted August 16, 2016 Type mysql -V in your terminal and paste the output here. Also, type df -h and, again, paste the output here. Kind regards, Michael! Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted August 17, 2016 Author Share Posted August 17, 2016 I have space .. root@vds:~ # mysql -V mysql Ver 14.14 Distrib 5.6.27, for FreeBSD10.1 (amd64) using EditLine wrapper root@vds:~ # df -h Filesystem Size Used Avail Capacity Mounted on /dev/ada0p2 46G 19G 23G 45% / devfs 1.0K 1.0K 0B 100% /dev root@vds:~ # Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted August 18, 2016 Author Share Posted August 18, 2016 jump Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted August 19, 2016 Author Share Posted August 19, 2016 no ideea ? Link to comment Share on other sites More sharing options...
Premium imWelly 26 Posted August 21, 2016 Premium Share Posted August 21, 2016 On 8/16/2016 at 1:39 PM, DeYaN. said: so , you are move the mysql from /var/db/ in ex : /usr/home/db ? and that`s all, ? fix ? actually i moved it to /home not /usr/home and it worked perfectly Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted August 23, 2016 Author Share Posted August 23, 2016 (edited) I use a link .. it`s a goog ideea`? Edited August 24, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
iltizio 217 Posted August 23, 2016 Share Posted August 23, 2016 (edited) 5 hours ago, DeYaN. said: I use a link .. it`s a goog ideea`? You have only one filesystem, root. So that operation is not helpful. You don't have space problem like other users. Your problem may be a wrong use of MySQL or you still use old storage engine like MyISAM that have a lot of bug. Evaluate to upgrade to mariadb to upgrade MyISAM to Aria storage engine. Edited August 24, 2022 by Metin2 Dev Core X - External 2 Internal Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted August 25, 2016 Author Share Posted August 25, 2016 On 8/23/2016 at 0:49 AM, iltizio said: You have only one filesystem, root. So that operation is not helpful. You don't have space problem like other users. Your problem may be a wrong use of MySQL or you still use old storage engine like MyISAM that have a lot of bug. Evaluate to upgrade to mariadb to upgrade MyISAM to Aria storage engine. Hmm , at MariaDB i lost a big time with the mysql dump , Don`t work with db data files from /var/db ? Quote Link to comment Share on other sites More sharing options...
iltizio 217 Posted August 25, 2016 Share Posted August 25, 2016 It could work, but it's not the correct way. Mysql dump it's the best way. It require a lot of time only if you have a lot of data, but for metin2 it isn't. If you don't want to wait some minutes for a full dump, you can exclude to dump db log for data, and backup only the structure of this db. You can take 10 minutes. Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted September 3, 2016 Author Share Posted September 3, 2016 upp , another ideea? Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted September 4, 2016 Author Share Posted September 4, 2016 On 8/25/2016 at 10:36 AM, iltizio said: It could work, but it's not the correct way. Mysql dump it's the best way. It require a lot of time only if you have a lot of data, but for metin2 it isn't. If you don't want to wait some minutes for a full dump, you can exclude to dump db log for data, and backup only the structure of this db. You can take 10 minutes. Yeah, but i must make a full data for my players :)) So,i need a full dump proto , hm .. my database have about 3gb :-? 4 years .. Link to comment Share on other sites More sharing options...
iltizio 217 Posted September 4, 2016 Share Posted September 4, 2016 3gb is nothing. Big databases have Tb of data and you can export it with something like 2 days. To create dump fastest you can create it from command line directly on your machine with mysqldump: http://dev.mysql.com/doc/refman/5.7/en/mysqldump.html if you had thought of it before, you would not have these problems. To you still went well you have the solutions, others have lost everything because they only thought about the gameplay, and not what's underneath. This is one of the main reasons why the metin2 servers fail. You're still in time to remedy. For table that write a lot of data like player.item, player.player, log.* The best solutions is to use XtraDB for MariaDB or the old InnoDB for Mysql. This storage engine hasn't crash bug like MyISAM. To temporaly solve this problem on your table you can changevthe storage engine. With this storage engine you can't take anymore backup from datafile, but only with dump. You need to take backup with dump always for a lot of reasons, but now it's mandatory, if you want a backup that you can use. This solution isn't enought. You need to think at the other thing if you want to continue with your project. Link to comment Share on other sites More sharing options...
DeYaN. 29 Posted September 13, 2016 Author Share Posted September 13, 2016 I`m upgrade the server to MariaDB but i have the same problem .. wtf Link to comment Share on other sites More sharing options...
iltizio 217 Posted September 13, 2016 Share Posted September 13, 2016 43 minutes ago, DeYaN. said: I`m upgrade the server to MariaDB but i have the same problem .. wtf On 23/8/2016 at 9:49 AM, iltizio said: Evaluate to upgrade to mariadb to upgrade MyISAM to Aria storage engine. https://mariadb.com/kb/en/mariadb/aria-storage-engine/ enable also: PAGE_CHECKSUM TABLE_CHECKSUM 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now