patternsqlMinor
All My Databases Are Gone?
Viewed 0 times
aregonedatabasesall
Problem
Today I changed my username and password in MySQL and I logged into phpmyadmin to see that all my databases were gone.
I've tried changing the datapath but then I realized I didn't see any of my databases in the data folder either!
Can I get back my databases? Are they stored somewhere else?
I've tried changing the datapath but then I realized I didn't see any of my databases in the data folder either!
Can I get back my databases? Are they stored somewhere else?
Solution
Data is present in data folder of MySQL which is usually in ProgramData for windows installations. look into "C:\ProgramData\MySQL\MySQL Server 5.6"..as programdata usually have the files on by default
Context
StackExchange Database Administrators Q#103836, answer score: 4
Revisions (0)
No revisions yet.