Learn SQL Database Programming

Restoring a database

In this section, we will walk through how to restore a database to a MySQL Server instance. Restoring is the process of taking a backup (or copy) of a database and turning it back into a database on the same database server with a different database name or on a separate database server with the same database name as the original database. You can also restore over a database on a server – in other words, replacing the current database with a backup of the database – but be cautious with this because you will lose data if the database has changed since the last backup. When you back up a MySQL database, the backup process creates SQL files of the entire structure and data of the database. When you restore a database ...