The Series of MySQL -2- MySQL Workbench - EP 02_04
HI Hi, Greetings! 
Happy January 
Hi Everyone,
Today, I would like to share with you an article about the second episode of Series of MySQL (MySQL Workbench), and the content is given below.
a. MySQL Workbench environment deployment
b. MySQL Workbench Editions
c. MySQL Workbench Administration Tool
d. MySQL Workbench Manager (Create, Alter, Drop Delete)
e. MySQL Workbench Database Export and Import
MySQL Workbench Database Export and Import
In this section, we'll look at how to use the MySQL Workbench to export and import a database or table.
Databases Export (Tables)
1. To export databases or tables, go to the Menu bar, pick Server, and then Data Export, as shown in the screen below. It will bring up a new window with data export choices and preferences.
2. Choose any database, and it will show you all of the tables that belong to that database. To include the database in the Export file, we can tick one or more database checkboxes here. Similarly, we can select one or more tables from the window's left area.
3. Let's choose two databases, namely (mydb1 and mydb2), which will contain all of the tables in this database.
Dump Data and Structure:
Both the table structure and the data rows will be saved.
Dump Data Only:
Only the inserted rows in the tables will be saved.
Dump Structure Only:
It will only store the table structure, which is made up of database columns and data types that we create.
4. You can choose the export path you want under the Export option. I'm going to stick with the default settings here. There are also two radio buttons, which are discussed further below.
Export to Dump Project Folder:
All of the tables will be saved as independent SQL files in a single folder. It will come in handy when importing or restoring individual tables from an export file.
Export to Self-Contained File:
All databases and tables will be stored in a single SQL file. When you want to import all of the databases, tables, and data rows into a single SQL file, this is a viable solution.
5. The progress meter and log appear when you click the Start Export button. To find the export files, go to your system's Document folder.
Databases to Import (Tables)
1. Go to the Menu bar, choose Server, and then select the Data Import option to import databases or tables. It will bring up a new window with data import choices and settings.
2. Here you'll see the two radio buttons for importing databases and tables:
Import from Dump Project Folder
Import by using Self-Contained File
3. Select 'Import from Dump Project Folder' and then 'Load Folder Content' to see all of the databases available in the project folder.
4. Select the myDB database and the relevant product table from the Data Import option.
5. To import the databases and tables from the backup file, select the 'Dump Structure and Data' option and click the Start Import button.
6. Finally, refresh the Schema->mydb->table to show the currently imported database or table.
You are welcome to like and leave feedback in the comment area.
Link:
EP 02_01:
The Series of MySQL -2- MySQL Workbench - EP 02_01
EP 02_02:
The Series of MySQL -2- MySQL Workbench - EP 02_02
EP 02_03:
The Series of MySQL -2- MySQL Workbench - EP 02_03
Source:
· https://www.w3schools.com/mySQl/default.asp
· https://www.mysqltutorial.org/mysql-basics/
M M Zaheer Hussain
Stay Safe!
