Restoring a single database from a complete MySQL database dump

Scenario:

You are working as MySQL / MariaDB database administrator.  You are provided a complete MySQL or MariaDB database dump but you need to restore only one database out of entire database dump. What steps you will take to restore single database from complete MySQL database Dump.

Solution:

To create the single database dump file you can use below command.

mysqldump -u UserName--password=PasswordforUser--all-databases >/DestinationDirectory/BackupFileName.sql

To Restore single database from complete backup dump, you can use below command.
mysql -u [UserName] -p[Password] --one-database destdbname < alldatabases.sql

You need to create the empty database first before you run the restore database command. Let's say we need to restore abc database, then you can use below command.

mysql -u root -p --one-database abc < /mysqlbackup/alldbs.sql

Video Demo: How to Restore One Database From All Database mysqldump



1 comment: