IPGraySpace: MYSQL - How to import restore data base in MYSQL using workbench

3 years ago
31

IPGraySpace: MYSQL - How to import/restore the database in MySQL using workbench

In the previous video, we showed...

IPGraySpace: MYSQL - How to take database import/backup using MYSQL workbench

This video shows how to...
How to import/restore the database in MySQL using workbench

1. Open MYSQL workbench (login in as root)
In the previous video, we took the backup from the 'test' database
In this, we are restoring 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 database 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 database"
B. Watch IPGRAY video "IPGRAY - how to download and install MySQL workbench"
c. Watch IPGRAY video "IPGRAY - How to take database backup using MYSQL workbench"

4. run the export wizard

Follow more IPGraySpace videos
-----------------
thank you for watching the IPGraySpace video
please share, subscribe, and comment

visit
www.ipgray.com
www.ipgrayspace.com
for more IT articles, documents, and videos

Loading comments...