[AbRASiON]

Anyone have any recommendations on how to migrate to a new computer when you're using MySQL?

I've got a very old XBMC install (which has been upgraded over the top to about a 13.1 alpha)
I believe I still have MySQL 5.5 as my DB, I recall a major bug being found with 5.6 sometime in the last 6 months, I think it's been fixed?
(New users to MySQL, XBMC were having major issues following the tutorial, apparently an issue was found in MySQL 5.6 itself lacking a function?)


I'm curious what the best course of action is? I could just try installing MySQL 5.5, copying my entire old PC's MySQL 5.5 directory over.
Install XBMC13, copy my old XBMC directory over the top. (and /profile / user dir entries)
Upgrade latest XBMC version

I am almost positive that will get me up and running but it's not particularly "clean" Any tips on a cleaner install?

[Ned Scott]

I believe the 5.6 issues are fixed. I'm not sure if there's really any difference (XBMC-wise) between MySQL 5.5 and 5.6.

Are you moving where the video files are or just the MySQL installation?

[AbRASiON]

The video files are all still going to be on the same NAS / share.
I've decided to just try and setup from scratch again, it's been several years and I'm sure some mess is in there.

I will say #@$% the MySQL web developers / whoever maintains their installer, I'm having real difficulty getting the latest version.
http://dev.mysql.com/downloads/mysql/
Clearly states "MySQL Community Server 5.6.20 "
If you download their official "installer" (the first main link)
It says "MySQL Installer 5.6.19" Ok sure, so they haven't updated the installer - but it's going to be clever enough to get the latest version of the server, right?
Nope, it downloads 5.6.19.

Problem is the "raw" install for 5.6.20 server here http://dev.mysql.com/downloads/file.php?id=453193 doesn't initiate the configure the database wizard that their official installer application does.
So I'm having trouble just getting the latest version on there, it's quite confusing.

[AbRASiON]

Update:
Seems I simply went to their page at exactly the wrong time, they were mid version change.
I found the installer tool here.
http://cdn.mysql.com/Downloads/MySQL-5.6...winx64.msi

It installs all kinds of crap but, it does work properly and it's the latest version.
I must admit I kind of want my watched list so I'm not sure if I should import / export from the old one or not, we'll see.

[Ned Scott]

You should be able to migrate from the old database files, but I haven't done anything like that in a long time, so I'm not sure on the exact steps.

[lrusak]

Code:

mysqldump -u root -p******* --all-databases > my-databases.sql

Or that's what it would be on linux/bsd

Then, to import

Code:

mysql -u root -p***** < my-databases.sql

[AbRASiON]

Is this still factually correct?
http://wiki.xbmc.org/index.php?title=Add...ie_Scraper

This scraper is currently the flagship of the Team-XBMC scrapers.

Any reason why it's still not included in XBMC as default?

[Ned Scott]

I don't think it ever got updated for v13. Not sure what's going on there.

[AbRASiON]

I've been using it without issue under 13 since the launch of 13? I think.