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

Posted on 2009-02-10
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
Question by:Cerixus
    LVL 26

    Accepted Solution

    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
    LVL 1

    Author Closing Comment

    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!
    LVL 26

    Expert Comment

    You are most welcome.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now