105Backup - amagerard/FreeRadius GitHub Wiki

HOME

RedHat/Daloradius

01- Synoptic 02 Network 03 Daloradius 04 Selinux
05 Backup 06 GnomeShell 07 Accounting
FreeRadius OpenLdap ADserver

5. Backup.

5.1 Save and restore the sqlradius database.

Save the sqlradius database.
mariadb-dump -u root -p sqlradius > backup_sqlradius.sql

Save only data.
mariadb-dump -u root -p --no-create-db --no-create-info sqlradius > backup_sqlradius_data.sql

Restore the postfixadmin database.
mariadb -u root -p sqlradius < backup_sqlradius.sql

Restore only date.
mariadb -u root -p sqlradius < backup_sqlradius_data.sql

Change password.
mariadb -u root -p mysql
MariaDB [mysql]> select user,host,password from mysql.user;
alter user 'username'@'localhost' identified by 'NewPassword';