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

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