srakatours.blogg.se

1. #Mysql workbench sql tabs stay open when shut dowwn closed install#
2. #Mysql workbench sql tabs stay open when shut dowwn closed full#

Leave HeidiSQL open, we'll come back to it shortly.īefore continuing, it is very important that you backup your database before you even begin. For your username and password, you can use the same ones you use for Kodi. The only settings that need to be changed are the hostname, username, and password. Open HeidiSQL and configure a connection to your database.

#Mysql workbench sql tabs stay open when shut dowwn closed install#

You will need to grab and install a copy of HeidiSQL or similar SQL editing program (note that instructions will be based on HeidiSQL).īe sure that all of your Kodi clients using your MySQL database are shut down and will not be started again until we are completely finished. To put it very simply, we are going to keep the same media but move it to a new file path. There are other times when this is necessary, but these examples will give you an idea of the purpose of these instructions. You want to move from local sources to network sources.You are replacing a hard drive that is dying but cannot or do not want to replicate the path exactly as before.You are restoring your media from a backup to a new location/machine.You are using external hard drives connected to your PC and need to move to a new PC.

#Mysql workbench sql tabs stay open when shut dowwn closed full#

These instructions are written from a Windows environment. With this in mind, I will be doing all of this using a program that will help make novice users more comfortable (hopefully) navigating this process. The target audience here is the complete novice to all of this, so veteran users (particularly those well versed in SQL and SQL queries) will be able to cut out the majority of these instructions and simply follow the queries. Those with sufficient SQL query experience can go to the Methode 1 - TL DR section below, and start right of the bat. There are basically two types of Kodi users when it comes to MySQL usage: the complete novice and the veteran computer users with SQL knowledge. The goal is to be able to relocate your media without disrupting your current library or being forced to scrape all of the media over again. This guide is to help you move your media to a new location without losing all of your current watched status, date added, last played, resume time (for shows/movies that you started watching and did not finish), etc.