AXISHK
asked on
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
Tks
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
Just copy the "data" folder and you're set.
HTH,
Dan
ASKER
Tks, Normally, where is the data folder for mysql. I install WAMP on my Window platform, Tks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
but you might try - if it works it works, if not - you will go thru normal backup/restore cycle.