Ways to create dump with SQLdeveloper without involvement of importing and exporting

Asked By Finlay 50 points N/A Posted on - 12/07/2012

What available ways exist to allow create dump with sqldeveloper without the possibility of utilizing the import or export functionality on the sql tool?

 

• Status: Open
• Question Views: 895
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Shifflett Laurel

Go To Solution

Best Answer

Best Answer

Answered By Shifflett Laurel 0 points N/A #194917

Ways to create dump with SQLdeveloper without involvement of importing and exporting

I am giving the information how to create a dump file .For this I have used the built in key

mysqldump which  writes the statement of sql file.

shell> mysqldump [arguments] > file_name

To dump all databases, invoke mysqldump with the –all-databases option:

shell> mysqldump --all-databases > dump.sql

To dump only specific databases, name them on the command line and use the –databases option:

shell> mysqldump --databases db1 db2 db3 > dump.sql

The –databases option causes all names on the command line to be treated as database names. Without this option, mysqldump treats the first name as a database name and those following as table names.

With –all-databases or –databases, mysqldump writes CREATE DATABASE and USE statements prior to the dump output for each database.

If you want to cause the dump file to force a drop of each database before recreating it, use the –add-drop-database option as well.

To dump a single database, name it on the command line:

shell> mysqldump --databases test > dump.sql

In the single-database case, it is permissible to omit the –databases option:

shell> mysqldump test > dump.sql

To dump only specific tables from a database, name them on the command line following the database name:

shell> mysqldump test t1 t3 t7 > dump.sql

I hope this will help

Thanks

Shifflett Laurel 

 

About Shifflett Laurel

Questions
2

Answers
154

Best Answers
78

• Vote Up 0 Vote Down

• Posted on - 01/22/2013
• Question Category: MySQL Server

Answered By Kevinn Nicholas 0 points N/A #194918

Ways to create dump with SQLdeveloper without involvement of importing and exporting

 

 

 

For Data dump in SQL, SQL Developers have added a support to create it without using export and import tools. This support is added in DBA navigator including some new and extra features.

Data Pump utility is server oriented so there is no need to transfer data between server and client.

• Just need to create the script.
• Run it in the client machine.
• Data dump will be created in oracle server side. 

About Kevinn Nicholas

Questions
3

Answers
40

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 01/23/2013
• Question Category: MySQL Server