MariaDB FAQ

How to dump a Mariab database ?

See also

• https://mariadb.com/kb/en/library/backup-and-restore-overview/#mysqldump

mysqldump -u root -p<password> --dump-date --databases --tz-utc {dbname} > {dbname}.sql

How to delete a database

drop database <db_name>

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| db_test            |
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
5 rows in set (0.00 sec)

MariaDB [(none)]> drop database db_test;
Query OK, 25 rows affected (0.35 sec)

MariaDB [(none)]> show databases;                                                                                                                                                                                                            +--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.00 sec)