IPGRAY : MYSQL - How to import / restore data base in mysql using workbench

IPGRAY : MYSQL - How to import / restore data base in mysql using workbench

IPGRAY : MYSQL - How to import / restore data base in mysql using workbench

In previous video we showed ....

IPGRAY : MYSQL - How to take data base import / backup using MYSQL workbench

This video shows how to...
How to import / restore data base in mysql using workbench

1. Open MYSQL workbench (login in as root)
In previous video we took the backup from 'test' data base
In this we are restroing the backup sql script to 'new-test' schema
Open the script change the 'test' schema to 'new-test' save the file
if you don't do this then the restore will happen in the 'test' schema
just to make sure the 'new-test' schema and tables are creating successful
from the backup script we are doing this..extra step

2. Make sure the mysql data base is up and running
3. Choose the backup sql file to import

If you don't have steps 1, 2 and 3

A. Watch IPGRAY video "IPGRAY - how to download and install mysql data base"
B. Watch IPGRAY video "IPGRAY - how to download and install mysql workbench"
c. Watch IPGRAY video "IPGRAY - How to take data base backup using MYSQL workbench"

4. run the export wizard

thank you for watching
follow up IPGRAY videos on youtube

please subscribe