woolyg Posted April 3, 2008 Share Posted April 3, 2008 Hi all, In my infinite wisdom and staggering ineptitude, I had a crash and lost all of the info on my testing webserver. I've since reinstalled the webserver, and am about to get into re-integrating my MYSQL files from a backup. I'm running XAMPP on a windows machine, and in the mysql/data folder there are folder entries for the various databases I set up. My question is - Once I have recreated the blank DB of the same name of the original DB, is it OK to simply go and grab the relevant .frm / .MYD / .MYI files from the backup, and copy them to the DB's folder? ... or are there implications of doing that? All info appreciated. Woolyg. Quote Link to comment Share on other sites More sharing options...
luca200 Posted April 4, 2008 Share Posted April 4, 2008 The best way would be having a dump (that means a file in which you have all sql commands to recreate the db), but if you don't have it, you can try that way. Given that all your tables were MyIsam table, of course. Quote Link to comment Share on other sites More sharing options...
woolyg Posted April 4, 2008 Author Share Posted April 4, 2008 Yeah, they're all myISAM - I'm in the middle of attempting it now! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.