Memphiz Wrote:the integer is the db structure version ... its just same as it was with sqlite before ... devs "just" made it more equal to each other ...
Hi all,
I could use some help on this, too.
I am running Pre-Eden from Dec 11th, 2011 on an htpc.
1. created the user 'xbmc'
2. granted permissions
mysql> show grants for xbmc;
+-----------------------------------------------------------------------------------------------------+
| Grants for xbmc@% |
+-----------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'xbmc'@'%' IDENTIFIED BY PASSWORD 'blabla' |
| GRANT ALL PRIVILEGES ON `%`.* TO 'xbmc'@'%'
+-----------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
3. let xbmc create the database on its own
4. imported my library
5. entered the name of the newly created database in advancedsettings.xml
6. restarted xbmc
7. xbmc copied the database to a new one
8. I changed the *.xml to point to the new database
Now, on every restart, xbmc creates a new database that I cannot connect to, because the name differs from the one in the .xml. It keeps counting up.It's like a vicious circle.
MyVideos58
MyVideos5858
MyVideos585858
...
...
Before Pre-Eden I ran my box with Dharma 10.1 (Live)
In addition I ran xbmc on my ipad; the nightly from Dec 10th.
First I installed mysql on xbmclive Dharma 10.1.
Strangely enough everything was fine. My ipad would update the database and the library would'nt be compatible with 10.1 anymore. But at least the upgrade was done only once. After that I was able to use the database with the ipad.
Any ideas?
I woul greatly appreciate any help
PS: I also tried connection as 'root'; same thing happened