
Learn Database Export and Import using MySQL Workbench. Open MySQL Workbench and logged in to MySQL database server using ‘root’ username and password. In previous couple of videos we learned how to Create, Alter, Drop Databases and Tables and also how to Insert, Read, Update, Delete data rows using MySQL Workbench. In this lecture we will learn how to Export and Import the database using MySQL Workbench.
First of all to Export the databases or tables, from top menu ‘Server’ select ‘Data Export’ Option, which opens a new window of data export settings and options. The left section on the window displays all the existing databases on our MySQL database server. When we select a database by clicking on it, it displays all the respected tables under the selected database. We can select one or multiple database check-boxes to include the database in the Export file. Under ‘Export Options’ section, You can change the default export path of you choice. I’ll keep the default one. By selecting first option that is ‘Export to Dump Project Folder’. MySQL Workbench will save the save all tables as separate SQL file under one folder. Which is useful when you will be importing or restoring the export file one by one table. I’ll go ahead quickly and first save as ‘Export to Dump Project Folder’, MySQL Workbench displays the progress bar and log. Now, I’ll again export the database using ‘Export to Self-contained File’ option.
To demonstrate the import first I’ll delete the existing ‘students’ table under ‘mytestdb’ database. Display database details by clicking on ‘i’ symbol, select ‘tables’ tab. Select and right click ‘students’ table, and click ‘Drop Table’ option, confirm and delete the table. Click ‘refresh’ to update the tables section and we have no table in our ‘mytestdb’ database. Now select the database and from ‘data import’ window, select ‘import from dump folder. ‘Load folder contents’ and select only ‘mytestdb’ database and click start import button to import ‘students’ table again. Go to ‘mytestdb’ database information window again and click ‘refresh’ button to reload table list again. and the ‘students’ table is back.
Check out the whole playlist of MySQL Workbench Introduction Tutorials or Individual video from the following links,
MySQL Workbench Tutorial: Introduction to MySQL Workbench for Beginners Playlist
MySQL Workbench: Understand What is MySQL Workbench?
MySQL Workbench Add User and Connect to Database
MySQL Workbench Create, Alter, Drop Database
MySQL Workbench Create, Alter, Drop Table
MySQL Workbench Insert, Read, Update, Delete Data Rows
MySQL Workbench Database Export and Import
Subscribe to my channel:
Nguồn: https://saesrpg.net/
Xem thêm bài viết khác: https://saesrpg.net/giai-tri/
Xem thêm Bài Viết:
- TRÒ CHƠI "XOẮN NÃO" DỄ QUẠO NHẤT VỤ TRỤ | Nabee TV
- Conversation with foreigners in English | Learn English for all levels
- Cố Chấp – Về Nơi Đâu (Phần 1) – TraCy Thảo My [ Official Music Video ]
- Học trực tuyến trên truyền hình MyTV: Giải pháp tối ưu mùa Covid-19
- Hướng dẫn sử dụng tính năng Điều khiển tivi (Remote Controller) trên MyTV và MyTV Net
TRÒ CHƠI "XOẮN NÃO" DỄ QUẠO NHẤT VỤ TRỤ | Nabee TV
July 13, 2020
20 comments
Leave a reply Cancel reply
-
10 UFC Grapplers Fighters Don't Want To Mess With
July 11, 2020 -
25 Ý TƯỞNG ỐP ĐIỆN THOẠI DIY VỪA DỄ VỪA NGẦU
July 11, 2020
Thank you
How does it work if we have a large Excel data base. Let's say either a large Excel workbook with multiple Worksheet and/ or tables? Can we import? Can we keep the cell types, formats and structure. etc?
Not working for me
Thanks. Very helpful.
Thank you
how can i import triggers and stored procedure from database in mysql workbench
thank you, but you should have made the scripts for the video first, that might have shortened the video under 3 mins. but again thank you, it helped
merciiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii
Thank You! You explained very well
COOL
Thank you for
detailed video!!!
Thank you.
This looks nothing like the ipower Mysql dashboard I'm using.. I need to backup my database and I'm stuck.
can you tell me how to import log files in mysql server
Hello, although u selected dump structure & data, but while u had exported the students table had 1 row.(could see it before u deleted) and after u imported, students table had 0 rows..
Why is the data not loaded when u imported ?
how can I import an xml file
Hey!
I found your video very helpful.
Please, can you provide me the setup of this MySQL workbench and tell me how can I set up exactly like. Because I need the same setup but I am unable to create it.
Good Day
I love this voice, so much!
Excellent! thank you for your explanation…
I have dump file database not SQL. How can I do?