Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 146
  • Last Modified:

Copy whole mySQL database to another computer

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
AXISHK
Asked:
AXISHK
  • 2
1 Solution
 
Radek BaranowskiFull-stack Java DeveloperCommented:
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
 
Dan CraciunIT ConsultantCommented:
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
 
AXISHKAuthor Commented:
Tks, Normally, where is the data folder for mysql. I install WAMP on my Window platform, Tks
0
 
Dan CraciunIT ConsultantCommented:
wamp\bin\mysql\mysql5.x.xx\data
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now