Steps
- Stop service
windows: services.msc
Service Name: MariaDB - move db data files into the new data folder
(Remember to include folder “mysql”) - remember to copy file “ibdata1” as well or it will cause “table doesn’t exist” error.
- Restart service
Reference:
- https://www.arekibo.com/blog/restore-a-mysql-database-from-backed-up-program-files-(-frm-myd-myi)-no-sql-dump-required!/
- https://www.752club.com/mariadb-mysql-table-doesnt-exist-in-engine-error/