That title will mean little to most of you but let me explain.
Earlier this year we built a web based program for a customer. We installed it on one of their Windows machines and they are into the swing of using it. Then disaster! The machine fails. Luckily for us the disk was intact and no data was lost which means that the MqSQL database we set up in our program should be intact. The only problem in being how do I get it across onto the rebuilt machine intact.
A quick search on google revealed this link http://www.nerdydork.com/restoring-mysql-innodb-files-on-windows.html which gave us the advice we needed.
Just to short cut we copied the data folder with the .frm files. We also then copied the complete configuration file - we did not worry about editing parts of it.
Database restored. Day saved. Heart rhythm can return to normal. Stress ball out of the window.
Once again a big thanks to Nerdy Dork and all those out there that give freely of their advice.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment