I forgot to backup my InnodB database then i want to restore the table and data
You are viewing an old version of this question. View
the current version here.
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
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?
Comments
Comments loading...
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.
