mysql -u xclnews -p xclnews-drupal < /big/dom/xclnews/www/drupal/database/database4.0.mysql I did a telnet or SSH session and entered the above command at a command prompt. Then I get a request for password, enter password and then I get a "2002 error, can't connect to local mysql server through socket '/tmp/mysql.sock' " Any help PLEASE
Well, I did a search on this 2002 error and there are easy three or four suggested solutions, geez, how is one to know which to use?? ----- Original Message ----- From: "Tony Budak" <TonyBudak@CLNews.org> To: <support@drupal.org> Sent: Monday, May 22, 2006 1:49 AM Subject: [support] 2002 error mysql -u xclnews -p xclnews-drupal < /big/dom/xclnews/www/drupal/database/database4.0.mysql I did a telnet or SSH session and entered the above command at a command prompt. Then I get a request for password, enter password and then I get a "2002 error, can't connect to local mysql server through socket '/tmp/mysql.sock' " Any help PLEASE -- [ Drupal support list | http://lists.drupal.org/ ]
mysql -u xclnews -p xclnews-drupal < /big/dom/xclnews/www/drupal/database/database4.0.mysql
Then I get a request for password, enter password and then I get a "2002 error, can't connect to local mysql server through socket '/tmp/mysql.sock' "
Any help PLEASE
Missing database name: try this for unix sockets:- [Replace "xclnews_db" with your database name] mysql -u xclnews -p xclnews-drupal -D xclnews_db < \ /big/dom/xclnews/www/drupal/database/database4.0.mysql or this for TCP connect:- mysql -u xclnews -p xclnews-drupal -h 127.0.0.1 -P 3306 -D xclnews_db < \ /big/dom/xclnews/www/drupal/database/database4.0.mysql regards --AjK
Hi AjK, I named my database "drupal". So in the first example, the command would be mysql -u xclnews -p xclnews-drupal -D drupal< \ /big/dom/xclnews/www/drupal/database/database.4.0.mysql Is this what you suggest? What does the -D signify? thanks, Tony ----- Original Message ----- From: "AjK" <drupal@f2s.com> To: <support@drupal.org> Sent: Monday, May 22, 2006 3:35 AM Subject: RE: [support] 2002 error
mysql -u xclnews -p xclnews-drupal < /big/dom/xclnews/www/drupal/database/database4.0.mysql
Then I get a request for password, enter password and then I get a "2002 error, can't connect to local mysql server through socket '/tmp/mysql.sock' "
Any help PLEASE
Missing database name: try this for unix sockets:- [Replace "xclnews_db" with your database name] mysql -u xclnews -p xclnews-drupal -D xclnews_db < \ /big/dom/xclnews/www/drupal/database/database4.0.mysql or this for TCP connect:- mysql -u xclnews -p xclnews-drupal -h 127.0.0.1 -P 3306 -D xclnews_db < \ /big/dom/xclnews/www/drupal/database/database4.0.mysql regards --AjK -- [ Drupal support list | http://lists.drupal.org/ ]
Hey Folks, This command line did the job and brought up the Drupal... mysql -hmysql.clnews.org -u xclnews -p xclnews-drupal < /big/dom/xclnews/www/drupal/database/database.4.0.mysql Thanks Tony Budak ----- Original Message ----- From: "Tony Budak" <TonyBudak@CLNews.org> To: <support@drupal.org> Sent: Monday, May 22, 2006 2:24 PM Subject: Re: [support] 2002 error Hi AjK, I named my database "drupal". So in the first example, the command would be mysql -u xclnews -p xclnews-drupal -D drupal< \ /big/dom/xclnews/www/drupal/database/database.4.0.mysql Is this what you suggest? What does the -D signify? thanks, Tony ----- Original Message ----- From: "AjK" <drupal@f2s.com> To: <support@drupal.org> Sent: Monday, May 22, 2006 3:35 AM Subject: RE: [support] 2002 error
mysql -u xclnews -p xclnews-drupal < /big/dom/xclnews/www/drupal/database/database4.0.mysql
Then I get a request for password, enter password and then I get a "2002 error, can't connect to local mysql server through socket '/tmp/mysql.sock' "
Any help PLEASE
Missing database name: try this for unix sockets:- [Replace "xclnews_db" with your database name] mysql -u xclnews -p xclnews-drupal -D xclnews_db < \ /big/dom/xclnews/www/drupal/database/database4.0.mysql or this for TCP connect:- mysql -u xclnews -p xclnews-drupal -h 127.0.0.1 -P 3306 -D xclnews_db < \ /big/dom/xclnews/www/drupal/database/database4.0.mysql regards --AjK -- [ Drupal support list | http://lists.drupal.org/ ] -- [ Drupal support list | http://lists.drupal.org/ ]
Tony, when sending to any list, it is probably a good idea to replace hostnames, usernames and (encrypted) passwords with a dummy text, like: mysql -hmysql.example.com -u username -p my-drupal-database < /path/to/drupal/database/database.4.0.mysql I advice you to make sure your password is STRONG, that is, not guessable. Also, limiting access to specific hosts might be a good thing, if not done already. Although security trough obscurity is not a good thing, why make any hacking attempt easier? :) Kind regards, Vincent de Lau vincent@delau.nl gsm: 06-22089744
Yes of course, I should have known that, thanks for the advice, had my priorities, elsewhere... thanks again ----- Original Message ----- From: "Vincent de Lau" <vincent@delau.nl> To: <support@drupal.org> Sent: Monday, May 22, 2006 3:01 PM Subject: RE: [support] 2002 error Tony, when sending to any list, it is probably a good idea to replace hostnames, usernames and (encrypted) passwords with a dummy text, like: mysql -hmysql.example.com -u username -p my-drupal-database < /path/to/drupal/database/database.4.0.mysql I advice you to make sure your password is STRONG, that is, not guessable. Also, limiting access to specific hosts might be a good thing, if not done already. Although security trough obscurity is not a good thing, why make any hacking attempt easier? :) Kind regards, Vincent de Lau vincent@delau.nl gsm: 06-22089744 -- [ Drupal support list | http://lists.drupal.org/ ]
participants (3)
-
AjK -
Tony Budak -
Vincent de Lau