Kodi Community Forum
MYSQL, restore from database. not dump - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: MYSQL, restore from database. not dump (/showthread.php?tid=172355)



MYSQL, restore from database. not dump - TBinfection - 2013-08-29

Looking for a bit of help with MySQL please Smile

Had a system disk failure on the box with my shared DB, I have my SQL data but have had to reinstall MySQL.

I've looked for how to restore from the raw data (I don't have a dump) but all the articles I can find discuss restoring from dump.

Any clues...?


RE: MYSQL, restore from database. not dump - theredguy - 2013-08-29

If you install the exact same version of MySQL you should be able to just drop your data files back into the data directory (make sure MySQL is not running at the time you do that). It should be somewhere like C:\Program Files\MySQL\data or something like that. I know this works in Linux, I don't see why it wouldn't in Windows (assuming that's what you are running).


RE: MYSQL, restore from database. not dump - Ned Scott - 2013-08-30

You can create a dumb using the SQLite DB by removing the advancedsettings.xml file temporarily, so that XBMC goes back to using SQLite. Then you have something to reimport into MySQL.


RE: MYSQL, restore from database. not dump - TBinfection - 2013-08-30

(2013-08-29, 22:14)theredguy Wrote: If you install the exact same version of MySQL you should be able to just drop your data files back into the data directory (make sure MySQL is not running at the time you do that). It should be somewhere like C:\Program Files\MySQL\data or something like that. I know this works in Linux, I don't see why it wouldn't in Windows (assuming that's what you are running).

Thanks!

This did it, I had to mess about with log sizes as the default installs created different sizes but all good now, thanks a lot.