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

Is it possible to restore a mysql database from the filesystem?  

ie, D:\Program Files\MySQL\MySQL Server 4.1\data\databasename
LVL 1
CerixusAsked:
Who is Participating?
 
UmeshConnect With a Mentor MySQL Principle Technical Support EngineerCommented:
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
0
 
CerixusAuthor Commented:
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!
0
 
UmeshMySQL Principle Technical Support EngineerCommented:
You are most welcome.

Thanks,
Umesh
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.