How To: Export and Import Data with dbForge Studio for MySQL

How To: Export and Import Data with dbForge Studio for MySQL


Learn how to export and import MySQL and MariaDB data using Data Export and Import tools from Devart!
Learn more: http://www.devart.com/dbforge/mysql/studio/data-export-import.html
Closed Caption:

Welcome to dbForge Studio for MySQL
- import data from XLS file,
Right-click a connection or a database, and
select Import Data from the shortcut menu.
Select an import format and a file you want to
import.
On the Destination table page, select New or
Existing table for import.
On the Options page, select the cell range for
header and for data.
You can select data from rows or from columns.
You can also specify what data will be used as
a header: the first row in a range, another range,
or do not include header at all.
The data range can be selected automatically
When you change the data range, the header
On the Data Formats page, you may also select
format for all columns,
or for each column separately.
On the Mapping page, you can correct the table
columns, add new columns etc.
Let's modify columns.
The wizard allows to select the import data
mode: appending, bulk insert or single
transaction.
On the next page, you can set the errors
handling options.
Let's perform data import once more.
Add new data to the same table, type it's name
to the Filter box.
Select the first row in a range.
The data range selected automatically or manually.
As you see, there are no changes in mapping.
Select Append/Update mode.
Select Use a single transaction
and start importing.
Now, let's take a look at the table data.
Here is our result.
You can export data right form Data editor.
Alternatively, you may select the option from the
shortcut menu.
Select export to SQL.
Select Open the result file after export.
Besides, you can save and load templates,
which can be used when working with command
line.
On the Source page, you may select the tables
or views that will be exported either to a
separate file, or to a single file.
On the Options page, you may select the
statement type: insert, update, delete, merge.
On the Table columns page, you can exclude
certain columns from export, set key, and
modify column names.
On the Exported rows page, you can select a
range of the exported rows: all rows, selected
rows only, a range of rows.
Here is our result.
Now, we will demonstrate one more export
example - export of selected columns.
We have filtered data and selected rows for
export.
Let's select to open the result file after export.
As you see, we the file name corresponds to the
table name.
Select MERGE statement type.
Next, select Export selected rows only.
Here is the result.
You have been watching the dbForge Studio for
MySQL Tutorial.
Thank you for watching.

Video Length: 02:58
Uploaded By: Devart
Published: 2/13/2015
View Count: 15,187

Related Software Products
dbForge Studio for MySQL
dbForge Studio for MySQL

Published By:
Devart

Description:
dbForge Studio for MySQL: A Full MySQL and MariaDB IDE With a Debugger, Compare Tools and Reports dbForge Studio for MySQL is Devart's Windows IDE for MySQL and MariaDB: a SQL editor with smart completion, a stored procedure debugger, a visual query builder and database designer, backup and restore, and, in the Professional edition, schema and data compare with sync scripts. Professional costs $179.95 a year (Standard $99.95, Enterprise $229.95...


Related Videos
How to create MySQL foreign key between two tables?
How to create MySQL foreign key between two tables?

Video Length: 01:34
Uploaded By: Devart (7/1/2013)
View Count: 96,329

MySQL and MariaDB client for Windows with GUI environment
MySQL and MariaDB client for Windows with GUI environment

Video Length: 04:17
Uploaded By: Devart (8/11/2014)
View Count: 25,437

How to create a simple connection using dbForge Studio for MySQL?
How to create a simple connection using dbForge Studio for MySQL?

Video Length: 02:54
Uploaded By: Devart (4/24/2014)
View Count: 20,026

How to Optimize MySQL Queries with Query Profiler by Devart?
How to Optimize MySQL Queries with Query Profiler by Devart?

Video Length: 02:58
Uploaded By: Devart (4/24/2014)
View Count: 18,197

How to debug MySQL procedures using dbForge Studio for MySQL?
How to debug MySQL procedures using dbForge Studio for MySQL?

Video Length: 02:54
Uploaded By: Devart (4/24/2014)
View Count: 16,438

Ultimate MySQL and MariaDB GUI Tool - #dbForge Studio for MySQL
Ultimate MySQL and MariaDB GUI Tool - #dbForge Studio for MySQL

Video Length: 06:28
Uploaded By: Devart (4/4/2018)
View Count: 13,669

What is the Best GUI tool for MySQL? Comprehensive overview of dbForge Studio for MySQL
What is the Best GUI tool for MySQL? Comprehensive overview of dbForge Studio for MySQL

Video Length: 05:51
Uploaded By: 0xSECRETenv (9/29/2022)
View Count: 6,992

How to connect to MySQL Database using dbForge Studio for MySQL [Easiest way]
How to connect to MySQL Database using dbForge Studio for MySQL [Easiest way]

Video Length: 04:58
Uploaded By: Devart (9/14/2021)
View Count: 6,606

The most offbeat promo video for software!
The most offbeat promo video for software!

Video Length: 01:13
Uploaded By: Devart (5/26/2011)
View Count: 4,729

The Ultimate Guide to Version Control in dbForge Studio for MySQL
The Ultimate Guide to Version Control in dbForge Studio for MySQL

Video Length: 02:43
Uploaded By: Devart (11/3/2023)
View Count: 790

Copyright © 2026, Ivertech. All rights reserved.