IPGraySpace: MYSQL - How to import restore data base in MYSQL using workbench
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
-
3:09
IPGraySpace
3 years agoIPGraySpace: MYSQL - How to take data base backup using MYSQL workbench
23 -
7:18
IPGraySpace
3 years agoIPGraySpace: MySQL - How to use MySQL migration tool
16 -
6:42
Data analyst
4 months agoMySQL workbench not importing all rows from CSV | here is the solution | #sql
416 -
10:24
Gaming, Tech and whatever else
1 year agoExternal MySQL Database for WoW private server import Database
8 -
5:36
AnalyticsVoyage
7 months agoHow to Install MySQL Server and Workbench (Version 8.0.34) on Windows 11
164 -
13:09
Tech With Tim
4 years agoPython MySQL Tutorial - Setup & Basic Queries (w/ MySQL Connector)
19 -
2:29
AHMEDKAZEKA97
2 years agoFREE FULL COURSE Build Real World MYSQL Database Management Projects
238 -
11:27
Tech With Tim
4 years agoPython MySQL Tutorial - Selecting Data & Altering Tables
4 -
14:19
Shane Welcher
2 years agoUsing Python To Read PLC Data With Visual Studio By Importing Pycomm3
72 -
1:33
WeTechCareOfYou
3 months agoPowerShell Import Module cannot be loaded because running scripts is disabled on this system
31