up vote 0 down vote favorite
share [g+] share [fb]

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)

link|improve this question
100% accept rate
feedback

1 Answer

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.

link|improve this answer
thanks a million! – snusmu 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
feedback

Your Answer

 
or
required, but never shown
discard

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