The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

I forgot to backup my InnodB database then i want to restore the table and data

Dear ALL,

im a newbie in mariadB, i was use the mariadB 10.4(via Heidi SQL as interface) as my personal database in my notebook, last week my nb was crashed,i saved my data in HDD, now i want to restore my database through .opt , .frm and .idb files, please

note: i tried move the whole database folder into the new pc's mariadB dir: C:\Program Files\MariaDB 10.4\data but after i open up, i click the table shows that i need "show view rights" to modified.

Answer Answered by rambo john in this comment.

have you tried loging in from shell as root and used show databases;? If they show up in root and you can query your tables, it might just be you have to set up the user and grant access to the tables.

Else, file permissions?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.