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

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

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