[Ned Scott]

Do not create the tables, XBMC will do it for you. Read the wiki!

I followed the wiki verbatim, with one change that I got from a Website that showed how to use the <name></name> tag in advancedsettings.xml to specify specific database names for music and video. That's the part that I could not get to work.

I gave up on having control over that part , closed XBMC, removed the <name> tags, and restarted xbmc. It happily used the existing databases that imported from my old MySQL server and updated the libraries very quickly.

The idea of having custom databases named xbmc_video and xbmc_music is pretty appealing, because it makes them easy to identify as belonging to xbmc when you are browsing the mysql server schema. I'll just have to remember not to drop them when deleting obsolete tables during my quarterly db maintenance.

PS I'm using XBMC 11 Eden on Windows 7(32 and 64 bit), with MySql DB5 running on Ubuntu 12.04.

This mystery actually what lead to the Wiki instructions from excluding the name tag and just recommending to use the default name for the video DB. Several people couldn't get it to work when the <name> tag was included and we couldn't figure out why, but we never really collected any info in depth.

I've been meaning to install Ubuntu myself after having played with XBMCbuntu and wanting to expand on it, so I'll try and see if maybe it's something with MySQL DB5 and Ubuntu 12.04 (or a setting within?). I wish I had asked what others, who were having the same issue, were running for their MySQL server and what OS they were using. If anyone else is having this issue, if you could include that info, it might help.