Topic: erorr database
i need solve xampp is down and not work
i need recovery database
export from .frm .ibd to .sql file
plz help me for this
this is file database got from xampp\mysql\data
www.spacemac.us/news.rar
2 11/27/2018 10:02:21 pm (edited by poncho1234 11/27/2018 10:51:27 pm)
Re: erorr database
I've never done it but...
With ref to the 2nd answer here
It looks like you need the
-ibdata1
-ib_logfile0
-ib_logfile1
files as well, your zip file doesn't have them.
Look in the root of xampp\mysql\data, they should be there.
Also i think you need the name of the database, which would be the name of the folder you got your .frm .ibd files from or confirm it is 'news'
What happens if you create a new xampp installation and copy the above files there? Make sure mysql is off before you copy the files.
Googling 'restore mysql database from ibdata and .frm files' brings up lots of good suggestions
@apmuthu should be online later, maybe he can help?
The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/