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: https://www.youtube.com/channel/UCvrq9OowoORTV5Gs_jpADhw
20 replies on “MySQL Workbench Database Export and Import”
A really helpful tutorial even in 2021. Thanks for the help!
Awesome thank you so much!!
Thanks you very much. Man
Thanks for the video.
How is it possible to import a csv file and update the present data? I tried but it only adds new rows, I can't edit existing data.
Thanks for the lesson.
thanks dear , thankyou so much…..
Voice like a pockemon))) but good job
Very helpful video. Thank you
Thank you. Have been searching how to backup the db and keep getting command line tutorials, you are one of the very few to show how to do it using Workbench GUI.
should we already need the database to import it from dump file?
Thanks for your tutorial
This is great. Do you have any tutorial on how to open a pgd object (postgress database) in MYSql?
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.