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

mysql mysqldump mysql-error-2003
user291701 picture user291701 · Mar 25, 2011 · Viewed 32.6k times · Source

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

Answer

ypercubeᵀᴹ picture ypercubeᵀᴹ · Mar 25, 2011

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.

Related questions

How can I access the MySQL command line with XAMPP for Windows?

How can I access the MySQL command line with XAMPP for Windows?

Read More
Skip certain tables with mysqldump

Is there a way to restrict certain tables from the mysqldump command? For example, I'd use the following syntax to dump only table1 and table2: mysqldump -u username -p database table1 table2 > database.sql But is there a similar …

Read More
mysqldump data only

I am looking for the syntax for dumping all data in my mysql database. I don't want any table information.

Read More