Error in create back up in mysql through java program

Question

Runtime.getRuntime().exec("C:\\mysql\\bin\\mysqldump -u root -pmypassword  Databasename -r C:/backup.sql");

I am using this code to create back up from my sql. but It creates the empty file in the path.Because it is waiting in the command prompt to get the password. How can i give password to it Using command prompt directly when i press enter after typing, it asks password.After giving password,It creates the backup.Give me any solution for this Thanks in advance

@Arivu2020 any progress? did you solve your problem? If yes - mark an answer as accepted — Bozho
– Bozho, Commented Mar 17, 2010 at 12:51

Phil Rykoff · Accepted Answer · 2010-03-09 07:26:14Z

2

try the longer version

C:\mysql\bin\mysqldump -u root --password=mypassword Databasename -r C:/backup.sql

are you sure this password is correct?

answered Mar 9, 2010 at 7:26

Phil Rykoff

12.1k3 gold badges41 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bohemian · Accepted Answer · 2011-06-25 09:04:38Z

1

Leave a space between -p and mypassword, like this:

Runtime.getRuntime().exec("C:\\mysql\\bin\\mysqldump -u root -p mypassword Databasename -r C:/backup.sql");

Parameters to mysql commands often take two forms: The short form is -o value (with a space between), the longer form is --option=value (no space). You can't mix 'n' match the syntax.

answered Jun 25, 2011 at 9:04

Bohemian♦

427k103 gold badges604 silver badges750 bronze badges

Collectives™ on Stack Overflow

Error in create back up in mysql through java program

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related