Setup/Migrate MySQL Database


Export Database

Select the Data Export tab on Workbench this tab allows you to export your MySQL data. Select each schema you want to export, optionally choose specific schema objects/tables from each schema, and generate the export. Configuration options include exporting to a project folder or self-contained SQL file, optionally dump stored routines and events, or skip table data.

Select the Database objects to export, (MyVideos db) and configure the related options. (Create dump in single file and Include Create Schema)

Figure 5.40 Navigator Management: Data Ex
Navigator Management: Data Export: Object Selection

Optionally open the Advanced Options tab that allows you to refine the export operation. For example, add table locks, use replace instead of insert statements, quote identifiers with backtick characters, and more.

Figure 5.41 Navigator Management: Data Export: Advan
Navigator Management: Data Export: Advanced Options

Click Start Export to begin the export process:

Figure 5.42 Navigator Management: Data Export: Export Progress

Navigator Management: Data Export: Export Progress

This functionality uses the mysqldump command.

Data Import/Restore (New Server)

Restore exported data from the Data Export operation, or from other exported data from the mysqldump command.

Choose the project folder or self-contained SQL file, choose the schema that the data will be imported to, or choose New to define a new schema.

Figure 5.43 Navigator Management: Data Imp
Navigator Management: Data Import: Import From Disk

Click Start Import to begin the import process:

Figure 5.44 Navigator Management: Data Import: Import Progress

Navigator Management: Data Import: Import Progress
 
Your database should now have been restored onto the new server

Create XBMC user

  1. Open the "MySQL Command Line Client" from the MySQL start menu
  2. Enter the following commands:
    1. Type in: CREATE USER 'xbmc' IDENTIFIED BY 'xbmc'; and press return
    2. Type in: GRANT ALL ON *.* TO 'xbmc'; and press return
  3. Close out the command line tool

Now update the AdvancedSettings.xml file to point to the new database and restart your Kodi install, it should continue on the new server

Last update:
20-01-2016 12:44
Author:
Karl Hudgell
Revision:
1.0
Average rating:0 (0 Votes)

You cannot comment on this entry

Chuck Norris has counted to infinity. Twice.

Latest FAQs RSS

  1. Dockerized Download VM (30-01-2019 20:26)
  2. Jmeter + Performance Plugin + Jenkins Pipeline (16-02-2018 12:49)
  3. MySQL DB Backup Script (04-09-2017 10:16)
  4. Replace Cabin Filter (20-02-2017 13:45)
  5. Replace Nexus 6 Glass (15-02-2017 15:11)