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