Restore Database

Introduction

This topic describes how to restore a database backup with MySQL.

Requirement

We assume here you have already done back up of database following the Back up Database procedure described previously in this manual.

Create empty database with proper collation (name:dbipt_rcxx_yyyyyy / collation: utf8 - utf8_bin) to hold restored database.

To Restore the Backup

With MySQL Workbench (script)

•Open MySQL Workbench

•Access SQL Development panel

•Right click on database where you want to restore back up > Set as Default Schema.

•File > Open SQL script... > select backup file > press Open button.

•Press Execute button to execute script.

With Command Line

•Enter following command:

 # [mysql dir]/bin/mysql --user [username] --password="[password]" databasename  < [backupfile.sql]

[username] - this is your database username 

[password] - this is your database password

[databasename] - the name of your database to restore backup to

[backupfile.sql] - the backup file to restore

With MySQL Workbench (wizzard)

•Open MySQL Workbench

•Click Manage Import / Export under Server Administration on the right of the Workbench window.

•Click on Data Import/Restore on left side

•Select Import from Self-Contained File option

•Change path of sql script if needed

•Press Start Import button