View source for MySQL/Backup and restore databases

== GUI applications ==
=== PHPMyAdmin ===
PHPMyAdmin is a web interface that runs on an Apache web server and PHP instance that connects directly to your database server by way of your web browser, locally or outside your own network. It can be installed on Windows, Linux and Mac OS computers, as well as most NAS devices.

<gallery mode=packed-hover heights=300px caption="phpMyAdmin screenshots">
Phpmyadmin-export-1-method.png|Export ▶ Selection
Phpmyadmin-export-2-output.png|Export ▶ Output
Phpmyadmin-export-3-object-creation.png|Export ▶ Object creation
</gallery>
Open the PHPMyAdmin application and log in with a user with full credentials. The <code>kodi</code> user should have those credentials.
* '''Selection:'''
** Click on the '''<kbd>Export</kbd>''' tab, then select '''''<kbd>Custom - display all possible options</kbd>''''', making sure to have the correct database(s) selected.
* '''Output:'''
** Create your output filename in case you do not want to use the auto-generated default.
* '''Object creation:'''
** Include the <kbd>DROP DATABASE IF EXISTS</kbd> and
** <kbd>DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT / TRIGGER</kbd> statements

To begin the backup, click the Go button in the bottom left corner. A download link of the export file will be presented to you when the process has completed.

=== MySQL Workbench ===
[[File:Mysql workbench data export.png|right|frameless|x600px|MySQL Workbench]]
MySQL Workbench is a standalone database maintenance application which is available for Windows, Linux and macOS.

* From the main menu, select '''<kbd>Server</kbd>''', then the submenu item '''''<kbd>Export data…</kbd>'''''.<br />{{Note|To make a database the default selected database in MySQL Workbench for current and future sessions, double-click on the '''<kbd>MyVideos119</kbd>''' schema in the left side bar. The entry will then be displayed in boldface.}}
* '''Administration – Data Export:'''
** '''Tables to export:''' Select the schema(s) or database(s) you want to export, their respective data tables will be selected automatically.
** '''Export options:'''
*** Select '''''<kbd>Export to Self-Contained File</kbd>''''', and browse/create to the preferred folder and file name.
*** Include '''''<kbd>Create Dump in a Single Transaction</kbd>''''' as well as '''''<kbd>Include Create Schema</kbd>'''''.

Finally, press the '''Start Export''' button in the bottom right corner to start the database export. Exit the application if no errors were found.

=== HeidiSQL (MariaDB) ===
HeidiSQL is an overall database server tool, able to handle multiple types of database servers, but was primarily intended for MariaDB. It is available for a Windows OS only.
{{Clear|right}}