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

I've currently got a MySQL 5.X database on a server running Red Hat Linux 4 (from memory), which I currently shell into with Putty.
I now need to replicate the server in WAMP for offline debugging, and need to transfer the database over.

I've tried researching it, but everywhere says to just 'copy the files over' (and I CAN stop the MySQL service), but I'm not exactly sure how to do this in the shell (I DO have root access) and it feels... "icky".

Is there a recommended procedure / protocol for doing this?


share|improve this question

closed as off-topic by MDMarra, Dave M, Ward, mdpc, Jenny D Oct 9 '13 at 7:50

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions must be relevant to professional system administration. Server Fault is a site dedicated to professionals; novice questions are off-topic. Please see the Help Center for more information on topicality. The best advice we can give you is to hire a professional to help you out." – MDMarra, Dave M, Ward, mdpc, Jenny D
If this question can be reworded to fit the rules in the help center, please edit the question.

In order to copy your environment to your WAMP server you should dump your database and restore it in accordance with the MySQL documentation (this is for 5.6, but you can easily find the same page for other versions).

As a note for the future, your first stop for research should ALWAYS be the documentation for the product you're using (in this case, MySQL).
At least half of the information out there on the internet is written by blithering idiots -- trust the documentation from the people who wrote the software. It's correct far more frequently.

share|improve this answer

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