MYSQL, restore from database. not dump

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
TBinfection Offline
Junior Member
Posts: 25
Joined: Apr 2011
Reputation: 1
Post: #1
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...?
find quote
theredguy Offline
Member
Posts: 80
Joined: Jul 2013
Reputation: 1
Post: #2
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).
find quote
Ned Scott Offline
Team-Kodi Wiki Guy
Posts: 21,178
Joined: Jan 2011
Reputation: 276
Location: Arizona, USA
Post: #3
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.

You can make easy links to the XBMC wiki using double brackets around common XBMC words: [[debug log]] = debug log, [[Video library]] = Video library, [[SMB]] = SMB , [[userdata]] = userdata, etc
find quote
TBinfection Offline
Junior Member
Posts: 25
Joined: Apr 2011
Reputation: 1
Post: #4
(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.
find quote