Recover a MySQL database from files after upgrading to new version of XAMPP

Discussion in 'MySQL' started by Thodorompalos, Oct 12, 2018.

0
  1. #1
    Hello! I have a problem with a MySQL database that I haven’t been able to solve no matter how much I tried, either with internet guides or with free tools. I really don’t want to pay hundreds of dollars to a company so please, if anyone knows of a solution, help me because I’m desperate.

    I was running XAMPP 7.1.22 where I had said database and I decided to install XAMPP 7.2.10 without backing up the database. After that, the site wasn’t working so I figured the problem was the database. And indeed PHPMyAdmin wouldn’t recognize it. I reinstalled the previous version of XAMPP and the database was there but unfortunately I could only see the tables. The tables themselves were empty though. So no dump procedure worked and neither the site. Now all I have left is the folder with the database which contains all the .frm and the .ibd files, an .opt file, a .myd file and a .myi file. I also have the ibdata1 file.

    Any ideas or suggestions? Thank you very much for your time.
     
    Thodorompalos, Oct 12, 2018 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    When you start the mysql server, is it throwing any errors?
     
    jestep, Oct 18, 2018 IP
  3. Thodorompalos

    Thodorompalos Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #3
    No, none.
     
    Thodorompalos, Oct 18, 2018 IP
  4. Thodorompalos

    Thodorompalos Peon

    Messages:
    3
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    1
    #4
    Well after waiting and trying a lot, I decided to roll back the site and add the missing content again. Thanks for your time.
     
    Thodorompalos, Oct 19, 2018 IP