host problem.

[kaiserPT 12]

Hi, good afternoon / evening everyone, 

I am looking for someone to help me install some files on the host. I have some problems with DB and I've tried everything I could find by google, if anyone could help me I would be very grateful.

Can I make up for lost time.

with best regards, 

kaiserPT

 

[Metin2 Dev 4777]

this is wrong section  i think , and can you give us more details about you problem?

[kaiserPT 12]

First vive me this problemas wen i try tu use navicat

1033: - Incorrect information in file: './mysql/account.frm'

Then I did some research on google and found some solutions after applying such solutions gave me this error on the putty wen i Stuart the server

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[Sober 37]

Propably you replaced mysql database tables too.

I suggest you dump sql files of your databases that are necessary for metin2 game and homepage and import them to your database.

[kaiserPT 12]

I recompiled my DB again and give the same error. Then I tried with other files and remained the same.

The files in localhost work perfectly and without any problems

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[PACI 917]

service mysql-server status

 

If it isn't running, try to run it with:

service mysql-server start

[kaiserPT 12]

Pacificador i already made that. I try everyting i ser on google.

I think it's a bad installation of MySQL

[Denis 1471]

Install a newer version of mysql

[Shogun 4530]

check /var/db/mysql/hostname.err

[Rumor 2577]

http://metin2dev.org/board/topic/89-paid-service-server-installation-client-protection-for-metin2/

[Sober 37]

http://metin2dev.org/board/topic/89-paid-service-server-installation-client-protection-for-metin2/

 

You are out of the topic don't spam please

[Yiv 317]

He isn't out of the topic because he offers mysql installation. It's just a promotion. Maybe he could help you if you pay him.

 

But I think you aren't at the right section!

 

Back to topic: As the other said: Reinstall mysql!

 

Regards

[Dr3Ame3r 32]

portsnap fetch

-- then wait until it finishes

portsnap fetch extract

-- wait again

 

cd /usr/ports/databases/mysql55-server

make deinstall

 

wait again

then

 

cd /usr/ports/databases/mysql55-server

make install clean

 

then

ee /etc/rc.conf

mysql_enable="yes"

 

and voila .

You got clean MYSQL .

 

When you want to install a server or a backup from mysql.

Just delete other files than /var/db/mysql/mysql/

Delete the other files .

Then , drag and drop the files from your backup on /var/db/mysql/ folder

 

After the drag and drop process is done.

 

make these commands in putty

 

chown -R mysql /var/db/mysql/

chgrp -R mysql /var/db/mysql

mysql_upgrade --force

service mysql-server restart

and you're done .

 

 

Then , if you don't know how to reset password from mysql user.

https://mega.co.nz/#!oNBDQRJS!HgfzRbvT7DVF8yTLfFy26F4Jrsp8pTvpksvsAQd0j8Y

 

here you got some users .

decompress the archive , take user.xxx and place them into /var/db/mysql/mysql/ ( they are mysql 5.5 users )

then run

 

chown -R mysql /var/db/mysql/

chgrp -R mysql /var/db/mysql

mysql_upgrade --force

service mysql-server restart

 

 

That's it .

Free services of installing mysql . Cya ;d

 

If you still can't deal with it .

Just pm me , and i'll contact you as fast as possible .