Reader small image

You're reading from  Learn SQL Database Programming

Product typeBook
Published inMay 2020
Reading LevelIntermediate
PublisherPackt
ISBN-139781838984762
Edition1st Edition
Languages
Right arrow
Author (1)
Josephine Bush
Josephine Bush
author image
Josephine Bush

Josephine Bush has over 10 years experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using MySQL, SQL Server, Oracle, and PostgreSQL. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics.
Read more about Josephine Bush

Right arrow

Understanding SQL data import and export

In this section, we will walk through how to import and export data with the SQL data import and export processes in MySQL Workbench.

Importing via data import in MySQL Workbench

Let's walk through how to import data via the Management or Administration tab in the left navigation area. This is what we did in Chapter 2, Installing and Using MySQL Workbench, in the Learning how to restore a database section. Importing using data import is the same process as restoring a database in MySQL Workbench. Follow these steps:

  1. Open MySQL Workbench.
  2. Connect to your local or dev/test instance where you created your database in the last chapter.
  1. Click Administration or Management (depending...
lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Learn SQL Database Programming
Published in: May 2020Publisher: PacktISBN-13: 9781838984762

Author (1)

author image
Josephine Bush

Josephine Bush has over 10 years experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using MySQL, SQL Server, Oracle, and PostgreSQL. She is a Microsoft Certified Solutions Expert: Data Management and Analytics. She holds a BS in Information Technology, an MBA in IT Management, and an MS in Data Analytics.
Read more about Josephine Bush