MySQL/Backup and restore databases: Difference between revisions
< MySQL
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
Line 21: | Line 21: | ||
=GUI applications= | =GUI applications= | ||
==PHPMyAdmin== | |||
[https://www.phpmyadmin.net/ PHPMyAdmin] is a web-interface running on Apache and PHP that connects directly to your database server, locally or remote outside your own network. It can be installed on Windows, Linux and Mac OS computers, as well as most NAS devices. | [https://www.phpmyadmin.net/ PHPMyAdmin] is a web-interface running on Apache and PHP that connects directly to your database server, locally or remote outside your own network. It can be installed on Windows, Linux and Mac OS computers, as well as most NAS devices. | ||
Line 48: | Line 48: | ||
==MySQL Workbench== | |||
[https://www.mysql.com/products/workbench MySQL Workbench] is a standalone database maintenance application which is available for Windows, Linux and OS X. | [https://www.mysql.com/products/workbench MySQL Workbench] is a standalone database maintenance application which is available for Windows, Linux and OS X. | ||
Line 64: | Line 64: | ||
==HeidiSQL (MariaDB)== | |||
[https://www.heidisql.com/ HeidiSQL] is an overall database server tool, able to handle multiple types of database servers, but was primairily intended for MariaDB. It is available for a Windows OS only. | [https://www.heidisql.com/ HeidiSQL] is an overall database server tool, able to handle multiple types of database servers, but was primairily intended for MariaDB. It is available for a Windows OS only. | ||
=MySQLdump | =MySQLdump= | ||
<tabs> | |||
<tab name="Windows">MySQLdump script for Windows OSes</tab> | |||
<tab name="Linux"> | |||
= | |||
Using MySQLdump in Linux is also available, and is tpyically provided along with the mysql/mariadb-server installation. | Using MySQLdump in Linux is also available, and is tpyically provided along with the mysql/mariadb-server installation. | ||
Line 84: | Line 80: | ||
Copy the script below into your favorite text-editor and save it as a .sh (bash) file into the location+filename of your chosing, and make the file executable with: | Copy the script below into your favorite text-editor and save it as a .sh (bash) file into the location+filename of your chosing, and make the file executable with: | ||
You can export database contents for the Kodi video library, music library, and the database user for the Kodi application. You can do so separately or combined with all three parameters at the same time. | You can export database contents for the Kodi video library, music library, and the database user for the Kodi application. You can do so separately or combined with all three parameters at the same time. | ||
<syntaxhighlight lang="bash"> | <syntaxhighlight lang="bash"> | ||
#!/usr/bin/env bash | #!/usr/bin/env bash | ||
Line 163: | Line 161: | ||
# EXIT | # EXIT | ||
</ | |||
</tab> | |||
</tabs> | |||
'''BACKUP/RESTORE SCRIPT TO FOLLOW''' | |||
#Close out the command line tool | |||
<headertabs/> | <headertabs/> |
Revision as of 13:45, 25 January 2022
Incomplete: This page/section is under construction |