We help IT Professionals succeed at work.

restore mysql data from filesystem? (c:\program files\mysql\...)

Cerixus asked
Medium Priority
Last Modified: 2012-05-06
Is it possible to restore a mysql database from the filesystem?  

ie, D:\Program Files\MySQL\MySQL Server 4.1\data\databasename
Watch Question

Senior Principal Technical Support Engineer
Top Expert 2009
Yes, but tell me which Engine you are using?

 for MyISAM its easiest way.. just copy the folder(folder has DBNAME and it contain tables *.MYI,*.MYD,*.frm)

Make sure before copying to any MySQl server make sure the server is down..once copied you can restart server

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts


Wow, this is one of those things I should have filed under "Try before asking".  I just figured it was too good to be true.  Thanks!
UmeshSenior Principal Technical Support Engineer
Top Expert 2009

You are most welcome.

Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.