Solved

Copy whole mySQL database to another computer

Posted on 2014-11-27
4
139 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 34

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 34

Accepted Solution

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

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
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…
The viewer will learn how to count occurrences of each item in an array.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

776 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