I am trying to export a single table (location) from MySQL database (keep) but i can't do it by using java. Please help me.
preparedStatement = connection.prepareStatement("mysqldump –uroot –proot keep location> db_test.sql");
preparedStatement.execute();
connection.close();
For a single table here is the code. We can save this table to a file.
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/abc";
String username = "root";
String password = "root";
Connection connection = DriverManager.getConnection(url, username, password);
Statement stmt = connection.createStatement();
String filename = "d:/outfile.sql";
String tablename = "abc";
stmt.executeQuery("SELECT * INTO OUTFILE \"" + filename + "\" FROM " + tablename);
String filenamme = "d:/outfile.xls" and it worked perfectly.
Runtime.getRuntime().i think that is not a sql queryRuntime.getRuntime().exec("C:\\xampp\\mysql\\bin\\mysqldump –u root –proot keep location> db_test.sql");where does it save thanks btw