Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

while trying to run mysql/mysqldump i get an error

"Can't create TCP/IP socket(10106) when trying to connect"

is it possible to fix it? or is it possible to make a backup of mysql dbs in this situation somehow? what if i copy paste whole mysql install on another computer? (i know it's a wrong way but if it's the only way..)

why i need it is because my win xp installation got broken and i want to reinstall it - i cannot start apache(alloc_listener:failed to get a socket for and connect to internet anymore (wireless connection constantly says it cannot renew ip)

share|improve this question
up vote 1 down vote accepted

shutdown mysql and just take backup of mysql database files - to be on the safe side take all.

if you use innodb DO TAKE innodb log files as well : ib_logfileX and innodb data file: ibdataX

preferably try on another machine if data is readable and then peacefully reinstall the whole thing.

share|improve this answer
thanks a million! – Pavel K. Sep 9 '09 at 20:05
Make sure MySQL is shut down before doing this. Otherwise, you can get a corrupt backup (especially with InnoDB). Alternatively, look for one of the "hot copy" solutions out there. – Matt Solnit Sep 9 '09 at 21:46
@Matt Solnit you are absolutly right. i've corrected my answer. – pQd Sep 10 '09 at 7:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.