StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POCheck Backup was created
text
Body
copied!<p>I'm trying to learn JSP/Servlets... I managed to write a function that takes a backup of the whole database...</p> <pre><code>package com.functions; import java.io.*; import java.io.IOException; //import java.sql.Connection; //import java.sql.PreparedStatement; //import java.sql.ResultSet; //import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; //import com.functions.utility.DBConnector; public class addMarks3 extends HttpServlet { private static final long serialVersionUID = 8097085789553030042L; protected void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException { System.out.println("--------------------"); System.out.println(" On Backup.java "); System.out.println("--------------------"); fetchDataFromDB(request,response); } private void fetchDataFromDB(HttpServletRequest request,HttpServletResponse response){ try { Runtime runtime = Runtime.getRuntime(); File backupFile = new File("C:/Users/Rohan/Desktop/LMS/backup.sql"); FileWriter fw = new FileWriter(backupFile); Process child = runtime.exec("C:/Program Files (x86)/MySQL/MySQL Server 5.5/bin/mysqldump --user=root --password=root --lock-all-tables --opt dummy"); InputStreamReader irs = new InputStreamReader(child.getInputStream()); BufferedReader br = new BufferedReader(irs); String line; while( (line=br.readLine()) != null ) { fw.write(line + "\n"); } fw.close(); irs.close(); br.close(); } catch (IOException ex) { ex.printStackTrace(); } } } </code></pre> <p>I still cant figure out how to verify if the backup was successful..?? As in how do i check if the backup was succesfull or not. </p> <p>PS: The file does get populated everytime i run it.... </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload