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

We can't backup our Mysql DB. We have it under windows 2003.

It's mysql 5.1

So when we start dumping, the service stop after 3-4 sec.

The database work and the site it power work fine.

We need to move this DB to another server.

Thanks for any help

share|improve this question

migrated from stackoverflow.com Mar 9 '11 at 5:06

This question came from our site for professional and enthusiast programmers.

    
If the service stops, I guess the site goes down too? –  Stefan Hållén Mar 8 '11 at 19:35
    
If you can't get the dump working, and the server versions are very close, you could try just moving the mysql binary files and see if the new host can load them. –  Marc B Mar 8 '11 at 19:35
    
What mysql engine are you using? If it happens to be MyISAM you can simply move the data files one by one (3 files per table). –  Galz Mar 8 '11 at 19:54
    
How are you attempting to dump your database? Have you checked the logs to see if there are any hints there? –  Michael Madsen Mar 8 '11 at 20:25

1 Answer 1

you can use another way of backup as a workaround solution. you can use raw backup if it is MyISAM. just copy the data folder from old server to the new server.

share|improve this answer
    
Hi, In fact if I go table by table, only 2 tables cause the service to stop. I can open them, but not dump them. –  Patrick Desroches Mar 9 '11 at 17:00

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.