Got it

The Series of MySQL -2- MySQL Workbench - EP 02_04

Latest reply: Feb 25, 2022 06:46:14 719 33 23 0 0

The Series of MySQL -2- MySQL Workbench - EP 02_04

 

HI Hi, Greetings!  i_f47.gif 

Happy January i_f25.gif

 

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.


434443434343


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.


3444


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.


5555555555

 

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!

tt

The post is synchronized to: Author groupzaheernew's Author Collection

  • x
  • convention:

zaheernew
MVE Author Created Jan 14, 2022 15:30:03

  • x
  • convention:

Irshadhussain
Irshadhussain Created Jan 16, 2022 17:04:25 (0) (0)
 
azkasaqib
azkasaqib Created Jan 16, 2022 17:05:12 (0) (0)
 
Saqib123
Moderator Created Jan 14, 2022 18:17:26

Thanks for sharing
View more
  • x
  • convention:

zaheernew
zaheernew Created Jan 14, 2022 18:48:51 (0) (0)
Welcome  
Rumana
Created Jan 14, 2022 18:42:13

Very Interesting all parts are superb.
View more
  • x
  • convention:

zaheernew
zaheernew Created Jan 14, 2022 18:49:01 (0) (0)
Awesome  
BWGARM
Created Jan 15, 2022 01:32:27

The Series of MySQL -2- MySQL Workbench - EP 02_04-4602631-1
View more
  • x
  • convention:

BAZ
MVE Author Created Jan 15, 2022 18:45:23

Another good series to read
View more
  • x
  • convention:

zaheernew
zaheernew Created Jan 16, 2022 01:38:32 (0) (0)
Thanks for your feedback  
maithi
Created Jan 16, 2022 10:04:44

Good share
View more
  • x
  • convention:

Irshadhussain
Created Jan 16, 2022 17:04:31

Thanks for sharing
View more
  • x
  • convention:

azkasaqib
Created Jan 16, 2022 17:05:20

Thanks for sharing
View more
  • x
  • convention:

faysalji
Moderator Author Created Jan 17, 2022 05:37:47

Thanks for sharing
View more
  • x
  • convention:

123
Back to list

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.