I Want to take mqsyl batabase backup using jsp

I was develop web portal using jsp and servelt. I need to take backup my MySQL database and restore another one MySQL database.

View Answers

April 5, 2012 at 12:33 PM

import java.util.*;
import java.io.*;
public class BackUpSql {
public static void main(String[] args) {
try {
Runtime rt = Runtime.getRuntime();
rt.exec("cmd.exe /c start C:\\ab.bat");
System.exit(0);
}
catch(Exception ex){
ex.printStackTrace();
}
}
}

Here is the ab.bat:

set path=%path%;C:\Program files\MySQL\MySQL Server 5.0\bin;
mysqldump -uroot -proot register>C:\back.sql

where root is the username and password and register is the database.

For more information, visit the following link:

http://www.roseindia.net/mysql/mysqlbackuprestore.shtml

Ads

Advertisements

how to take backup of phone to pc using java code
how to take backup of phone to pc using java code i want to take the backup of phone data in my pc and also provide the restore functionality,and i want to do it using java program,so can anyone help me

I want this jsp answers
I want this jsp answers How can we declare third party classes... for particular jsp pages? If we want to develop any jsp pages using eclipse where we can... servlet? Can we print the messages by using the expressions in case of jsp

i want to do a project using jsp and servlet....What are all the materials i need to study
i want to do a project using jsp and servlet....What are all the materials i need to study i want to do a project using jsp and servlet....What are all the materials i need to study ? Please visit the following

how to take iphone backup using itunes
how to take iphone backup using itunes Hi, Can anyone please tell me how to take iphone backup using itunes..? You can find the details on apple website as well... anyhow i am giving you some tips as follow... How

What classes should I take if I want to become a data scientist?
What classes should I take if I want to become a data scientist? Hi... for the tutorials to learn: What classes should I take if I want to become a data... learn the topic "What classes should I take if I want to become a data

I want solution for this jsp program..
I want solution for this jsp program.. <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*" %> JSP Page <%! String

Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other and get the options from the database using JSP
Hi, I'm new to JSP I want to create 3 dropdown list each depend on the other and get the options from the database using JSP as i said i want... the database using JSP. like country,state,city..please guide me

i want to pass Javascript value to JSP scriptlet..
i want to pass Javascript value to JSP scriptlet.. i am having a problem that, i am having a combo box in the JSP page when i select an item from... now i want to pass this value to JSP scriptlet

I want design samples for JSP project
I want design samples for JSP project Sir, I world Like to do a project in jsp techonology. But i have no idea of selecting the project, especially if i selected any project i have no idea that is how to build ie how to design

using ajax i want to insert data into oracle database
using ajax i want to insert data into oracle database i would like to insert/update/select/delete from jsp to oracle database using ajax? please send a code for this iam using oracl database thank you

how to take a backup of a table in sql
how to take a backup of a table in sql how to take a backup of a table in sql? SQL BackUp Table example

java program to take backup for the folders
java program to take backup for the folders java program to take backup for the folders Have a look at the following link: Java Copy one folder to another

MySQL take backup of a table - example code needed
MySQL take backup of a table - example code needed How to take backup of a table in MySQL? I have a database which contains many tables. What is the command to take the backup of one table with data from database? Thanks

I want Image Album like -orkut and Facebook Using Struts 1.2
I want Image Album like -orkut and Facebook Using Struts 1.2 photo... to display all the images from the folder and i want to display it on JSP. like... in a database. it is neccessary..... I am using a link "Photo Gallery" to show

i want make a simple tools like turnitin using java
i want make a simple tools like turnitin using java it just simple tools can select the file like .doc,.pdf,.txt..the tools can read inside the file and make a searching at internet and give the source the source come from where

I want to display 10,000 records in a jsp page.Can I display page by page?
I want to display 10,000 records in a jsp page.Can I display page by page? When I submit a form it says "ERROR: Query request too large. Total rows... print page by page or have say 900 records per page in a jsp? Should I have

How i upload file and save that record in database using JSP?
How i upload file and save that record in database using JSP? Hi All, I m the beginner in JSP and I want to upload the file and store that file and some other form data in MySQL database. Ex. There is one employee detail form

sir/mam i want to have knowledge on live projects of java/jsp/servlets.Can you plz help me out
sir/mam i want to have knowledge on live projects of java/jsp/servlets.Can you plz help me out sir/mam i want to have knowledge on live projects of java/jsp/servlets.Can you plz help me out.I want to have a through knowledge

How I Upload File and Store that file name in Database using JSP
How I Upload File and Store that file name in Database using JSP Hi All, I m the beginner in JSP and I want to upload the file and store that file... this file). I refer the Employee Profile but it not work in my localhost server

i want to select a multiple value of check box by using onclick or onchange event without using from submission
i want to select a multiple value of check box by using onclick or onchange event without using from submission i have 4 check box name 1)profile... the result is ok but after getting value of first box now i want a result of second box

Ads