Jump to content
  • 0
chryxt

error import mysql please help

Question

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

Edited by chryxt

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

@@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 :)
 


 

Edited by chryxt

Share this post


Link to post
Share on other sites
  • 0

mysql -u root -prootpassword hercules1234_rag < main.

 

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.