How to manually dump a non-user MySQL database and copy it to another server

Introduction

This article describes how to manually dump a MySQL database and copy it to another server. Note that this article specifically covers non-user databases; refer to this article for how to dump and copy user databases:

How to import or restore a database via SSH

Procedure

1. Access the source server via SSH as the root user.
2. Dump the database with this command, replacing db with the name of the database to dump:

   mysqldump db > db.sql

3. Copy the database file to the destination server, replacing 203.0.113.21 with that server's IP address:

   scp db.sql root@203.0.113.21:/root

4. Access the destination server via SSH as the root user.
5. Create the database in MySQL:

   mysql -e 'create database db'

6. Import the database file into MySQL:

   mysql db < db.sql