Can't get mysqldump to connect to local mysql instance (error 2003 / 10061)

Question

I've got mysql 5.1 on a windows xp machine. It's listening on port 3308. I'm trying to use mysqldump:

> mysqldump -u root -pmypassword dbname > out.sql

Getting an error:

mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect

Not sure what the problem is, looking at --help dumps variables and shows port=3308 as I set in the mysql installation (instead of default 3306). I don't think there's anything different with my installation. I also tried explicitly setting the port # on the command line but still same error.

Thanks

simple test: try `telnet 127.0.0.1 3308`. Does it respond with a version number? — ypercubeᵀᴹ, Mar 25 '11 at 00:00
Have you tried `> mysqldump -u root -pmypassword -P 3308 dbname > out.sql` ? — ypercubeᵀᴹ, Mar 25 '11 at 00:05
Run `mysqladmin -u root -pmypassword variables` and check that `skip-networking` is `FALSE`. — ypercubeᵀᴹ, Mar 25 '11 at 00:19
using the -P version worked (I was using --port). Thank you all. — user291701, Mar 25 '11 at 00:45
@ypercube post this as an answer so that it can be accepted and easier to see in future ;) — David O'Meara, Mar 25 '11 at 01:43

score 9 · Answer 1 · answered Mar 25 '11 at 14:28

9

To connect through a port (and not the default 3306), use:

mysqldump -u root -pmypassword -P 3308 dbname > out.sql

Besides that, a simple test to see if MySQL responds at port 3308 is to try telneting:

telnet 127.0.0.1 3308

If MySQL is listening on port 3308, it'll respond with an error and the version running.

answered Mar 25 '11 at 14:28

ypercubeᵀᴹ

113,259
19
174
235

For a very large sql file this may help you `mysqldump --set-gtid-purged=OFF` – Ian Jan 20 '23 at 09:34

score 1 · Answer 2 · answered Jun 13 '13 at 07:06

1

Go to run type services.msc

then locate mysql service and start it .this solved

answered Jun 13 '13 at 07:06

user2144100

11
1

Yes. Its startup type is Automatic but it wasn't running. – Reg Edit Dec 17 '17 at 22:03

score 0 · Answer 3 · answered Mar 19 '13 at 11:44

0

If your Mysql-Client is 5.5.16 please upgrade it to 5.6.10, this process worked for me if your mysql server is 5.6.10.

answered Mar 19 '13 at 11:44

Anonymous

1

Can't get mysqldump to connect to local mysql instance (error 2003 / 10061)

3 Answers3

Linked