How to Maintain Export and Import MariaDB database Using SSH

Background Ability to sustain, import and export database is a necessity for database administrator to preserve smooth operations of a system. You may prefer to store database files locally and export it to production database in case you need it for quicker disaster restoration. Widely used database such as MySQL and MariaDB have similar approach in term of backup and recovery. Database dump is uncomplicated approach to deal with import and export of MySQL and MariaDB.