Restoring database through java application..?

[prabhurangan]

Hi Members,

I have to restore the mysql database through java application. I tried using the code
" Runtime.getRuntime().exec("mysql -u -p databasename < c:/backup.sql");"
But this is restoring the database.
But the same command works fine while running through command line.

Please provide some solutions to this issue.

Regards,
Prabhu.

[masijade]

It has to do with either the redirection or the path or both. Read When Runtime.exec() won't - JavaWorld thoroughly and carefully.

[prabhurangan]

Hi Masijade,

Im new to java, however i gone through it, but what i understood is, the process executed should be handled.

However do you have any idea of my problem, what goes wrong in my part.

[masijade]

There is no way that you thoroughly read the posted document and evaluated it's advice and suggestions against your code in the time between our posts.

Read that link, and use its advice. And bookmark it.

That link has everything you need (and could even want, except for a block copy and paste solution).

[prabhurangan]

I ran the sample code given in the link provided by you, but my command is not getting executed. Instead it provides the 'usage option' for mysql command.

My head is spinning masijade... Help me to figure out my mistake.

[prabhurangan]

run-main:
USAGE: java GoodWindowsExec <cmd>
osName : Windows XP
Execing cmd.exe /C C:\Program Files\MySQL\MySQL Server 5.0\bin\mysql -u user-p pass database < C:/backup.sql
ERROR>'C:\Program' is not recognized as an internal or external command,
ERROR>operable program or batch file.
ExitValue: 1


When i tried to execute, im facing this issue..............

[masijade]

Like I said, it has to do with your path, and that is covered in the link I gave you.