Restore XBMC/KODI mysql database after PC crash
#1
Hi Folks,

my old System SSD crashed, so I got a new SSD, installed a brand new Windows 8.1 and started to restore all of my data and backups.
Now its time to bring Kodi/xbmc back to life.

Befor the crash:
I had xbmc Frodo installed with a mysql 5.5 configuration
I have a backup (from the backup-addon within xbmc) and i have a mysql dump backup.

So what i tried to restore all my data:
Install Kodi Helix
Install mysql 5.6
setup the advancedsettings.xml
then i started Kodi and installed the backup-addon and restored my last backup.
After that, all the configuration (Addons, Skin, etc) was restored sucessfully, but no databases.
So then i tried to restore the mysql dump file but without luck.

Here is the output of "show databases"

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mymusic32 |
| mymusic48 |
| mysql |
| myvideos75 |
| myvideos90 |
| performance_schema |
| test |
+--------------------+
8 rows in set (0.00 sec)


I think there is something wrong with myvideos75 <-> myvideos90 maybe i have to copy all tables from the old 75 to the new 90 database Huh
Im not really used to all this mysql stuff - so could anybody help me with this?

Hope you understand my problem - sorry for bad english

greets !
Reply
#2
Just my 2 cents, but I would recommend using MySQL Workbench to backup you databases at least once a month. That way you could use it rather than a 3rd party app to Backup and Restore your databases

on a side note, first install frodo again and restore with the addon, then upgrade to Kodi and it will update your database to myvideos90
Image
Reply

Logout Mark Read Team Forum Stats Members Help
Restore XBMC/KODI mysql database after PC crash0