How import and export .sql

Question

How import and export .sql file by query. notice Using in jdbc

Are you asking about creating and loading an SQL dump file? If so, then the simple way is to use the database's sql dump / restore utilities, not JDBC. Just call it using the `Process` class. — Stephen C, Nov 07 '15 at 07:06
I want to store my data in my drive D or E by java app . I'm afraid of losing my data — Amr Emaish, Nov 07 '15 at 07:13

score 2 · Accepted Answer · edited May 23 '17 at 11:48

2

The importing part of your question has already been asked here "How to execute .sql script file using JDBC"

To do exporting you need to create a SQL queries to get data from every table in your database. Then write that data out to a file.

Your task of exporting data would be more simple using sql dump utilities, or MYSQL workbench.

Do export a single database via command line you can do this:

$ mysqldump -u [uname] -p[pass] db_name > db_backup.sql

edited May 23 '17 at 11:48

Community

answered Nov 07 '15 at 07:16

Whitecat

I want to export and import my data by statement (jdbc) – Amr Emaish Nov 07 '15 at 07:20
What statement? There are no single statements in java to do that. – Whitecat Nov 07 '15 at 07:21
Work only in CMD ?? $ mysqldump -u [uname] -p[pass] db_name > db_backup.sql – Amr Emaish Nov 07 '15 at 07:24
@AmrEmaish - That is correct ... though you can run that using `java.lang.Process` via a BAT or shell script. – Stephen C Nov 07 '15 at 10:41
@Stephen C - thanks , I'm trying :) – Amr Emaish Nov 07 '15 at 16:38

1 Answers1