Hi dear!

Here is my problem:

I got 2 computers, running for one under Win 2K server and the other under Linux Mandrake 9.2.

I got a HTTP server with a Mysql DB running on XP computer and i'd like to use Linux machine as Backup machine for my site.

So my wish is to import MySql DB on Linux and from Linux (Remotely).

So I type these command:

[root@linux_web root]# mysqldump --verbose --user=Linux -p --host=easytrading --add-drop-table --complete-insert easytrading > /easytrading.sql
Enter password:
-- Connecting to easytrading...
mysqldump: Got error: 2003: Can't connect to MySQL server on 'easytrading' (111) when trying to connect


But i still don't understand the error!

I created Linux User on my DB, with ALL GRANT PRIVILEGES.

I verified the port 3306 is open on the local computer by processing an telnet cmd: it's all ok

So could somebody tell me what happened when i use mysqldump remotely

Thanks

Have u tried using the IP address instead of the host name?

sure, it doesn't still work

You should give user "Linux" access to mysql *from all servers*, quite a common problem with mysql.

Try these 2 before re-issuing mysqldump on W2K System :
(mysql command line on server "easytrading")

grant all on easytrading.* to Linux@'%' identified by "<passwd_goes_here>";
grant all on easytrading.* to Linux@'localhost' identified by "<passwd_goes_here>";

Quite a common hassel wih mysql authorizations when connection remotely ...

Let us know if this did the trick

You might have addtional issues with codepages etc... when copying DBs form X to W