Mysql

From NixOS Wiki
Revision as of 11:10, 6 April 2024 by Maintenance script (talk | contribs) (rollback unauthorized mass edits)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

MySQL is a widely used open source relational database management system (RDBMS) that offers various features, tools, and services for data warehousing, analytics, machine learning, and more. MariaDB is a popular and stable fork of MySQL that is compatible with MySQL and has additional enhancements and features.

Setup

Setup and enable Mysql (MariaDB) database daemon

services.mysql = {
  enable = true;
  package = pkgs.mariadb;
};

Maintenance

Upgrade

NixOS will not run mysql_upgrade automatically for you after upgrading to a new major version, because it is a "dangerous" operation (can lead to data corruption) and users are strongly advised (by MariaDB upstream) to backup their database before running mysql_upgrade.

mysqldump -u root -p --all-databases > alldb.sql

After backup is completed, you can proceed with the upgrade process

mysql_upgrade