SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2010
    Location
    IN
    Posts
    93
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    help with mySQL files....

    would you mind letting me where MySQL stores the databases locally?

    i am working on WINDOWS Xp, and running mysql as localhost...

    my sys got crashed, OS got wired, HDD still works fine...

    would you plz help on that.....sothat i can locate the databases files and then reload them to new system.

    thanks in advance.

  2. #2
    SitePoint Enthusiast
    Join Date
    Jan 2010
    Location
    IN
    Posts
    93
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    btw i got the details....its always in

    C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.1\data

    and the file name is: ibdata1

    That's for if you want to backup it manually.

    one can copy this file for records and can paste in the same location to retrieve the databases and complete data.

    I added this here, sothat others may also enjoy this....

    enjoy!!!!!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •