find a position in navicat ?

[DeYaN. 28]

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

[imWelly 26]

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 

 

[DeYaN. 28]

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 ?

[MichaelM 40]

Type mysql -V in your terminal and paste the output here. Also, type df -h and, again, paste the output here.

 

Kind regards,

 

Michael!

[DeYaN. 28]

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:~ #
 

[DeYaN. 28]

jump

[DeYaN. 28]

no ideea ?

[imWelly 26]

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 

[DeYaN. 28]

I use a link .. it`s a goog ideea`?  

Edited August 24, 2022 by Metin2 Dev
Core X - External 2 Internal

[iltizio 215]

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

[DeYaN. 28]

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

 

 

[iltizio 215]

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.

[DeYaN. 28]

upp , another ideea?

[DeYaN. 28]

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 ..

[iltizio 215]

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.

[DeYaN. 28]

I`m upgrade the server to MariaDB but i have the same problem .. wtf

[iltizio 215]

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