MySQL Workbench Database Export and Import

20
5



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/

20 comments

  1. M Sadr 12 July, 2020 at 13:49 Reply

    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?

  2. Vipul Kumar Baloda 12 July, 2020 at 13:49 Reply

    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

  3. Dillinger R. 12 July, 2020 at 13:49 Reply

    This looks nothing like the ipower Mysql dashboard I'm using.. I need to backup my database and I'm stuck.

  4. Manjunath Prabhakar 12 July, 2020 at 13:49 Reply

    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 ?

  5. Fiesta Strikers 12 July, 2020 at 13:49 Reply

    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

Leave a reply