MariaDB /etc/mysql/debian-start

Authentic ๐Ÿ“‹ Debian 9 (Stretch) 42 lines

File Info

Size
42 lines
MD5
698c5abe65f83aec900a3f0e3500e758
SHA256
70cd8740d2a8163e0f354cf5959319efcdc0d65a1b7380b6940af9452d3648a3

Quick Commands

curl:
curl https://exampleconfig.com/api/v1/config/original/698c5abe65f83aec900a3f0e3500e758?hint=debian-start
wget:
wget -O debian-start https://exampleconfig.com/api/v1/config/original/698c5abe65f83aec900a3f0e3500e758?hint=debian-start
/etc/mysql/debian-start
#!/bin/bash
#
# This script is executed by "/etc/init.d/mysql" on every (re)start.
#
# Changes to this file will be preserved when updating the Debian package.
#
# NOTE: This file is read only by the traditional SysV init script, not systemd.
#

source /usr/share/mysql/debian-start.inc.sh

if [ -f /etc/default/mysql ]; then
  . /etc/default/mysql
fi

MYSQL="/usr/bin/mysql --defaults-file=/etc/mysql/debian.cnf"
MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf"
MYUPGRADE="/usr/bin/mysql_upgrade --defaults-extra-file=/etc/mysql/debian.cnf"
MYCHECK="/usr/bin/mysqlcheck --defaults-file=/etc/mysql/debian.cnf"
MYCHECK_SUBJECT="WARNING: mysqlcheck has found corrupt tables"
MYCHECK_PARAMS="--all-databases --fast --silent"
MYCHECK_RCPT="${MYCHECK_RCPT:-root}"

## Checking for corrupt, not cleanly closed (only for MyISAM and Aria engines) and upgrade needing tables.

# The following commands should be run when the server is up but in background
# where they do not block the server start and in one shell instance so that
# they run sequentially. They are supposed not to echo anything to stdout.
# If you want to disable the check for crashed tables comment
# "check_for_crashed_tables" out.
# (There may be no output to stdout inside the background process!)

# Need to ignore SIGHUP, as otherwise a SIGHUP can sometimes abort the upgrade
# process in the middle.
trap "" SIGHUP
(
  upgrade_system_tables_if_necessary;
  check_root_accounts;
  check_for_crashed_tables;
) >&2 &

exit 0

How to Install MariaDB

Alpine Linux

sudo apk add mariadb

Debian

sudo apt update && sudo apt install mariadb-server

Red Hat Enterprise Linux

sudo yum install mariadb-server

Ubuntu

sudo apt update && sudo apt install mariadb-server

Configuration File Location

File Path
/etc/mysql/debian-start
Directory
/etc/mysql/
Significance
System-wide configuration directory
Description
Files in /etc/ contain system-wide configuration settings that affect all users.

Quick Answers

When should I use this debian-start?

Use this file to restore MariaDB defaults after misconfiguration, for fresh installations, or as a customization baseline.

How do I restore MariaDB defaults?

Download this file, backup your current config, then replace /etc/mysql/debian-start. Restart MariaDB service.

Is debian-start safe for production?

Factory default from MariaDB on Debian 9 (Stretch). Safe baseline, but customize for your requirements.

How does this differ from other OS versions?

This config is from Debian 9 (Stretch). Other OS versions may have different defaults. Check compatibility section.

Can I use this for MariaDB troubleshooting?

Yes, compare this original config with your current settings to identify problematic modifications.