Jump to content
Maintenance ×
×
×
  • Create New...
  • 0

Database strange table problem


Crystal™

Question

  • Premium

I 've ordered a vps and i've installed my sfs succesfully but mob_proto table can't be readed ,it says that it is corrupted but i can open it fine in my other virtual memmory on my pc.

I have tried to import the sql file but again i am getting errors , the table is created but with no data ..

All the tables as i can see are fine except this..

When i try to add a mob with no query i get this message "1265 -  Data truncated for column 'size' at row 1 .

 

Link to comment
Share on other sites

6 answers to this question

Recommended Posts

  • 0
  • Premium

Okay i mananged to fix it after 20 minutes of posting it but i hadn't got connection to check the post..

Now when i open my server i get this error.

Spoiler

PUBLIC_IP:  interface vtnet0
HOSTNAME: channel1_core1
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
cannot open direct sql connection to host: localhost user: mt2 db: common
cannot start server while no common sql connected
mysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 seconds^Cmysql_real_connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   failed, retrying in 5 seconds
[email protected]:/home/game #
 

DB error file http://pastebin.com/Q0VhTp8T

Also i can't connect with navicat.

Link to comment
Share on other sites

  • 0
  • Premium

socket file  socket '/tmp/mysql.sock' is missing.

 

"Nothing's free in this life.

Ignorant people have an obligation to make up for their ignorance by paying those who help them.

Either you got the brains or cash, if you lack both you're useless."

Syreldar

Link to comment
Share on other sites

  • 0
9 hours ago, Syreldar said:

socket file  socket '/tmp/mysql.sock' is missing.

with mysql over localhost connection, mysql client use unix sockets to connect on mysql server. Navicat doesn't use unix sockets, so there is a problem with mysql-server. It means it is stopped.

Check mysql alert log /var/db/mysql/<hostname>.err

  • Love 1
Link to comment
Share on other sites

  • 0
  • Premium
4 hours ago, iltizio said:

with mysql over localhost connection, mysql client use unix sockets to connect on mysql server. Navicat doesn't use unix sockets, so there is a problem with mysql-server. It means it is stopped.

Check mysql alert log /var/db/mysql/<hostname>.err

http://pastebin.com/Q0VhTp8T I did posted it my friend thanks for your reply.What should I make?

 

Link to comment
Share on other sites

  • 0
  • Premium
2 hours ago, iltizio said:

From that log, you can see MySQL didn't write from 16/03/2017 at 18.

Contact your sysadmin ti check why mysql server service not start and not write in its log.

You mean to contact with my host?

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.


  • Activity

    1. 1

      Metin2 TitleBar Move Frezze

    2. 1

      Metin2 TitleBar Move Frezze

    3. 0

      Navicat "Trial" Reset

    4. 13

      Item ToolTip Width Fix

    5. 0

      Guild icon wrong position

    6. 3

      Monster health

    7. 4

      Luffy Pet

    8. 38

      Core X → Top Metin2 & Metin2 Download → Changelogs

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.