Jump to content

Database strange table problem


Recommended Posts

  • 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

  • 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
root@root599313:/home/game #
 

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

Also i can't connect with navicat.

Link to comment
Share on other sites

  • 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

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

  • 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

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

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.