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

Asked By 50 points N/A Posted on -
qa-featured

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

 
SHARE
Best Answer by Shifflett Laurel
Best Answer
Best Answer
Answered By 0 points N/A #194917

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

qa-featured

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 

 

Answered By 0 points N/A #194918

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

qa-featured

 

 

 

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. 

Login/Register to Answer

Related Questions