🔄 Exporting & Restoring
Export one database
mariadb-dump --user=<DB_USERNAME> --password --lock-tables --databases <DB_NAME> > /data/backup/db1.sql
Restoring
mariadb --user=<DB_USERNAME> --password <DB_NAME> < /data/backup/db1.sql
Export one database
mariadb-dump --user=<DB_USERNAME> --password --lock-tables --databases <DB_NAME> > /data/backup/db1.sql
Restoring
mariadb --user=<DB_USERNAME> --password <DB_NAME> < /data/backup/db1.sql
No Comments