current community

your communities

more stack exchange communities

Stack Exchange Inbox Reputation and Badges
tour help
Sign up ×
Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems. It's 100% free, no registration required.
up vote 0 down vote favorite

I want to create dump file of sqlite database from java but I can't run the below command from linux. I got the help of windows and I tried with linux but it appears one terminal nothing more than that. So can anyone help me how to write this command in linux?

  Process p = Runtime.getRuntime().exec("cmd /c start /b sqlite3 db.sqlite .dump > dump.txt");

My implementation in Linux is below:

String command= "/usr/bin/xterm"; 
Runtime rt = Runtime.getRuntime();  
Process p = rt.exec(new String[]{command , "/home/ubuntu/test.sqlite .dump > /home/ubuntu/newsql111.sql"});

Can anyone tell me where is my mistake?

share|improve this question

closed as off-topic by slm♦, Anthon, jasonwryan, rahmu, manatwork Oct 22 '13 at 8:02

  • This question does not appear to be about Unix or Linux within the scope defined in the help center.
If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers 2

up vote 0 down vote accepted

I found the solution:

 Process p = rt.exec(new String[]{"/bin/sh", "-c", "sqlite3 /home/ubuntu/testingdb.sqlite .dump > /home/ubuntu/success11.sql"});

It gives full dump file of sqlite database..

share|improve this answer
up vote 1 down vote

You don't need an xterm but you do need a sqlite3. That is you are running

/usr/bin/xterm /home/ubuntu/test.sqlite .dump > …

when you really need to run

/bin/sh -c "sqlite3 /home/ubuntu/test.sqlite .dump > …"

where I am assuming your database is …/test.sqlite. I'll leave the Java specifics to you.

share|improve this answer
    
when i running this code it gives me error.. java.io.IOException: Cannot run program "/bin/sh -c ": error=2, No such file or directory at java.lang.ProcessBuilder.start(ProcessBuilder.java:1029) at java.lang.Runtime.exec(Runtime.java:615) at java.lang.Runtime.exec(Runtime.java:483) at sqlitedbtest.Test.main(Test.java:22) Caused by: java.io.IOException: error=2, No such file or directory at java.lang.UNIXProcess.forkAndExec(Native Method) –  Java D Oct 22 '13 at 6:47
    
@msw.. hey when i run this command it works but when i am trying to dump in the folder where space in between name.. at that time does not work? –  Java D Dec 14 '13 at 10:29

Not the answer you're looking for? Browse other questions tagged or ask your own question.