error import mysql please help

chryxt

New member
Messages
16
Points
0
Github
chryxt
 Im newbie who still learn how make my own ps online
so im following this guide (http://herc.ws/wiki/Installation_%28CentOS%29)
I already have VPS server and then follow that guide but at this section

(Import MySQL Tables ) i always failing

1. cd sql-files/  ( its fail, so i tried this >> cd /home/hercules2006/Hercules/sql-files/ )
2. mysql -u root -prootpassword hercuser_rodb < main.sql  (its fail, so i change it into this >> mysql -u root -p hercuser_rodb < main.sql ) and...... error 2002 T_T it said Can't connect to local MySQL server through socket '/var/mysql/mysql.sock

This is the picture

http://postimg.org/image/jk3ecyobj/

Please anyone help me :')

Thanks a lot

And btw, can someone explain this ? I dont understand why and it still confuse me ><
http://postimg.org/image/r0jsufhxh/
 

Thanks Again ^^

 
Last edited by a moderator:
pm me i will set it up for you
default_heh.gif


 
Execute this

Code:
service mysqld start
Your MySQL seems to be down, above command will start it.
 
@@Dastgir

after following your guide to active (service mysqld start)
another problem shown
ERROR 1049 (42000): Unknown database 'hercuser_rodb'

is it because of this?
http://postimg.org/image/r0jsufhxh/

did i need to make new database like this?
mysql> CREATE DATABASE hercuser_rodb;

or changing
mysql -u root -p hercuser_rodb < main.sql

into

mysql -u root -p hercules1234_rag < main.sql

mind to explain?
Thanks before
default_smile.png

 

 
Last edited by a moderator:
mysql -u root -prootpassword hercules1234_rag < main.

Wiki will be updated soon, seems someone edited just like that, without checking previous db name

 
Back
Top