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

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

link|improve this question
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
feedback

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

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

1 Answer

up vote -1 down vote

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.

link|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
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.