Recover MySQL from DB data (.frm, .ibd)

Steps

  1. Stop service
    windows: services.msc
    Service Name: MariaDB
  2. move db data files into the new data folder
    (Remember to include folder “mysql”)
  3. remember to copy file “ibdata1” as well or it will cause “table doesn’t exist” error.
  4. Restart service

Reference:

  1. https://www.arekibo.com/blog/restore-a-mysql-database-from-backed-up-program-files-(-frm-myd-myi)-no-sql-dump-required!/
  2. https://www.752club.com/mariadb-mysql-table-doesnt-exist-in-engine-error/