Solved

Copy whole mySQL database to another computer

Posted on 2014-11-27
4
141 Views
Last Modified: 2014-12-10
I have setup WAMP and a php website on few local computers (for exhibition demonstration). The file hierarchy and web pages are identical. Can I simply copy a database files from one computer to other, without go through the dump backup and restore.

Tks
0
Comment
Question by:AXISHK
  • 2
4 Comments
 
LVL 11

Expert Comment

by:Radek Baranowski
ID: 40469003
No, I don't think so.

but you might try - if it works it works, if not - you will go thru normal backup/restore cycle.
0
 
LVL 35

Expert Comment

by:Dan Craciun
ID: 40469114
It should work if you don't have any activity before and during copy (best if you stop the Mysql servers on both computers).
Just copy the "data" folder and you're set.

HTH,
Dan
0
 

Author Comment

by:AXISHK
ID: 40469923
Tks, Normally, where is the data folder for mysql. I install WAMP on my Window platform, Tks
0
 
LVL 35

Accepted Solution

by:
Dan Craciun earned 500 total points
ID: 40470045
wamp\bin\mysql\mysql5.x.xx\data
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Developers of all skill levels should learn to use current best practices when developing websites. However many developers, new and old, fall into the trap of using deprecated features because this is what so many tutorials and books tell them to u…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question