Backing up and restoring a MySQL or MariaDB database is super easy. I’ve listed out a few different ways you can do it. Example MariaDB/MySQL

MySQL, MariaDB, and general SQL tips, functions, and how-tos.
Backing up and restoring a MySQL or MariaDB database is super easy. I’ve listed out a few different ways you can do it. Example MariaDB/MySQL
In some of these examples, particularly the remote server I’ve included usernames and passwords, but you might not need it locally, depending on your mysql
This example of a upsert, an on duplicate key insert statement in MySQL. What it does is if the table zipcode_population has a unique index