Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- how can i backup and restore date from mysql data base
- mysql> mysql -u root -p 123 -h hostname club <dumpfile.sql;
- ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -u root -p mehdi -h hostname club < dumpfile.sql' at line 1
- public static boolean backup(String mysqldumpPath, String backupPath) {
- boolean status = false;
- String username = "name";
- String password = "pword";
- String database = "database_name";
- String command = "/" + mysqldumpPath + "/mysqldump -u " + username + " -p" + password + " " + database + " -r " + backupPath;
- try {
- Process runtimeProcess = Runtime.getRuntime().exec(command);
- int processComplete = runtimeProcess.waitFor();
- if (processComplete == 0) {
- System.out.println("DatabaseManager.backup: Backup Successfull");
- status = true;
- } else {
- System.out.println("DatabaseManager.backup: Backup Failure!");
- }
- } catch (IOException ioe) {
- System.out.println("Exception IO");
- ioe.printStackTrace();
- } catch (Exception e) {
- System.out.println("Exception");
- e.printStackTrace();
- }
- return status;
- }
- public static boolean restore(String filePath){
- boolean status = false;
- String username = "name";
- String password = "pword";
- String[] command = new String[]{"mysql", "database_name", "-u" + username, "-p" + password, "-e", " source "+filePath };
- try {
- Process runtimeProcess = Runtime.getRuntime().exec(command);
- int processComplete = runtimeProcess.waitFor();
- if (processComplete == 0) {
- System.out.println("DatabaseManager.restore: Restore Successfull");
- status = true;
- } else {
- System.out.println("DatabaseManager.restore: Restore Failure!");
- }
- } catch (IOException ioe) {
- System.out.println("Exception IO");
- ioe.printStackTrace();
- } catch (Exception e) {
- System.out.println("Exception");
- e.printStackTrace();
- }
- return status;
- }
- //for testing
- public static void main(String args[]){
- String backupName = "D:/DatabaseBackup/backupHvs.sql";
- DatabaseManager.restore(backupName);
- }
- mysqldump --add-drop-table -u<username> -p<password> <databasename> > dumpfile.sql
- mysql -u<username> -p<password> <databasename> < dumpfile.sql
Add Comment
Please, Sign In to add comment