MySQL / MariaDB backup and restore

    and tagged as
  • sql

Quick snippet for manually backing up and restoring a MySQL / MariaDB database.

Backup mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

Restore mysql -u root -p[root_password] [database_name] < dumpfilename.sql