MySQL won't build tables
#1
I've been running a MySQL db for well over a year now and haven't had many problems once I got it set up. I decided to rebuild the video db as I was having a few minor problems and I thought a fresh db might solve them. I exported my library to a single file via XBMC settings and renamed the xbmc_video60 folder in MySQL. When I reboot XBMC, the xbmc_video60 folder is created, but no tables are built. This happens no matter whether I try it on my Openelec Eden RC2 machine or if I try it from my Windows Eden Final machine. Here is a log showing my first boot after I renamed the old db:

http://pastesite.com/33477

I even tried manually creating the db via MySQL command line using the following command:

Code:
CREATE DATABASE xbmc_video60 CHARACTER SET latin1 COLLATE latin1_general_ci;

I get the same result with that; the xbmc_video60 folder is created, but no tables. If I go ahead and try to import the library anyhow I get teh following log:

http://pastesite.com/33478

Am I doing something wrong? How can I recreate my library?
Reply
#2
Don't create the new DB. XBMC must create it. See: HOW-TO:Sync multiple libraries/Upgrading XBMC from v10 to v11 (wiki)
Reply
#3
I've tried letting XBMC create it and I get the same result. In fact, that's what I tried first. I only manually created the in an attempt to solve the problem.
Reply
#4
Thanks for the link Ned. Removing the name from my advancedsettings.xml did the trick.
Reply

Logout Mark Read Team Forum Stats Members Help
MySQL won't build tables0