Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 127.0.0.1) and connect to internet anymore (wireless connection constantly says it cannot renew ip)

share|improve this question

1 Answer 1

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

 
discard

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.