Backup & Restore MariaDb MySQL Using CLI



Backup Database

$ mysqldump database-name > backup-database-name.sql


Restore Database

$ mysql --database=database-name < backup-database-name.sql


Source :

https://stackoverflow.com/questions/42042241/how-to-perform-a-full-backup-of-a-mysql-mariadb-database

https://stackoverflow.com/questions/64410301/how-to-restore-mysql-database-from-a-sql-file

Comments