Working With Databases
install the following to enable "dump"
sudo apt install \
mysql-client \
mariadb-client
cat << EOT | tee my_env.env
MYSQL_ROOT_PASSWORD='<root-password>'
MYSQL_DATABASE='<database-name>'
MYSQL_USER='<user-name>'
MYSQL_PASSWORD='<user-password>'
source the file
source my_env.env
create the database
mysql -u $MYSQL_USER --password=$MYSQL_PASSWORD -e "CREATE DATABASE IF NOT EXISTS $MYSQL_DATABASE;"
mysql -u $MYSQL_USER --password=$MYSQL_PASSWORD $MYSQL_DATABASE < <filename>.sql
mariadb -u $MYSQL_USER --password=$MYSQL_PASSWORD -e "CREATE DATABASE IF NOT EXISTS $MYSQL_DATABASE;"
mariadb -u $MYSQL_USER --password=$MYSQL_PASSWORD $MYSQL_DATABASE < <filename>.sql
back up your database
#mysql command
mysqldump -u $MYSQL_USER --password=$MYSQL_PASSWORD $MYSQL_DATABASE > "$(date -I)-database-dump.sql"
#mariadb command
mariadb-dump -u $MYSQL_USER --password=$MYSQL_PASSWORD $MYSQL_DATABASE > "$(date -I)-database-dump.sql"
