Thread: Moving MySql Database from one machine to another machine

Hello vaishali,

Try this code:

import java.io.*;
 
public class sqlBackup {
 
    public static void main(String[] args) {
 
        //Location of the backup
        File test = new File("C:/mysql-5.0.27-win32/bin/backup.sql");
 
        FileWriter fw = null;
 
        try {
        fw = new FileWriter(test);
        Runtime rt = Runtime.getRuntime();
 
        //start output backup - change bjse to db name
        Process child = rt.exec("mysqldump -u root bjse");
        InputStream in = child.getInputStream();
 
        InputStreamReader xx = new InputStreamReader(in, "utf8");
        char[] chars = new char[1];     
        int ibyte = 0;
 
        while ((ibyte = xx.read(chars)) > 0) {
        fw.write(chars);
        }
        fw.close();
 
        System.out.println("OK! Completed");
 
        }catch(Exception e)
        {
        e.printStackTrace();
        } 
 
    }
}

You will also find this link very useful:

HowTo For Idiots: Backup MySQL Database From Java Part 1

Originally Posted by tpjava

You can use the mysql command mysqldump to copy contents of your database from the command prompt.

I know its not java code but if you do it programatically you will first have to install java etc...

Mysqldump –u root –all-databases > tmp.sql will save it to a folder where you can then use the reverse:

Mysqldump –u root –all-databases < tmp.sql to pull it back in on the new machine.

Hope it helps...

Thanks for your input tpjava.

I think the code I submitted above does something similar using mysqldump.