MySQL migration to a new machine. - Printable Version +- Kodi Community Forum (https://forum.kodi.tv) +-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33) +--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111) +---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228) +---- Thread: MySQL migration to a new machine. (/showthread.php?tid=201138) |
MySQL migration to a new machine. - AbRASiON - 2014-08-01 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? RE: MySQL migration to a new machine. - Ned Scott - 2014-08-02 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? RE: MySQL migration to a new machine. - AbRASiON - 2014-08-02 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. RE: MySQL migration to a new machine. - AbRASiON - 2014-08-02 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/mysql-5.6.20-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. RE: MySQL migration to a new machine. - Ned Scott - 2014-08-02 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. RE: MySQL migration to a new machine. - lrusak - 2014-08-02 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 RE: MySQL migration to a new machine. - AbRASiON - 2014-08-02 Is this still factually correct? http://wiki.xbmc.org/index.php?title=Add-on:Universal_Movie_Scraper Quote:This scraper is currently the flagship of the Team-XBMC scrapers. Any reason why it's still not included in XBMC as default? RE: MySQL migration to a new machine. - Ned Scott - 2014-08-02 I don't think it ever got updated for v13. Not sure what's going on there. RE: MySQL migration to a new machine. - AbRASiON - 2014-08-02 I've been using it without issue under 13 since the launch of 13? I think. |