Mysql Backup and Restore

Reading time ~1 minute

Backup

mysqldump --user=mysqluser --password=mysqluserpassword --all-databases > /backup/backupname_`date +"%Y%m%d"`.sql 

Restore

$ mysql -uroot -p
Enter password:
MariaDB [(none)]> use databasename;
MariaDB [databasename]>source /path/to/the/backup/sqlfile.sql;

Kubernetes Tutorials (1)

Published on June 16, 2017

Kubernetes How It Works

Published on January 22, 2017