How to take backup of database using jbutton | java swing | netbeans tutorials #35

[@emillawrence7767]

Sir how about sqlite... I can't do it because sqlite doesn't have mysqldump...

[@GSoftknowledge]

Just do as i have shown in the video.. but for backup button code will be changed..

[@GSoftknowledge]

Just create a connection and execute this- stmt.executeUpdate("backup to " + filename);

[@emillawrence7767]

@@GSoftknowledge i did this sir inside my backup button .... but i've got java.lang.NullPointerException PreparedStatement ps = null; Connection conn = null; conn = db.java_dbase(); //browsebutton JFileChooser path = new JFileChooser(); path.showOpenDialog(path); String date = new SimpleDateFormat("yyy-mm-dd").format(new Date()); try { File r = path.getSelectedFile(); location = r.getAbsolutePath(); location = location.replace('\\', '/'); filename = location + "_" + date + ".sqlite"; textField.setText(filename); }catch(Exception s) { s.printStackTrace(); } //inside backup button try { ps.executeUpdate("backup to" + filename); }catch(Exception s) { s.printStackTrace(); }

[@GSoftknowledge]

Your connection is not established that's why it's giving null exception

[@omkarjadhav5612]

I'm using oracle so mysqldump in not there... what i have to do now

[@ismailsaleh8535]

very useful content. i like it

[@mrpii.2k3]

with SQL sever ???

[@GSoftknowledge]

Yes

[@yusbunag5204]

Sir how about restore? Do you have a tutorial?

[@GSoftknowledge]

You can restore you .SQL file using cmd command

[@dieumercidiemsmamunga545]

How to restore ?

[@nalinthennakoon7853]

java.io.IOException: Cannot run program "C:/Program": CreateProcess error=2, The system cannot find the file specified p=runtime.exec("C:/Program Files (x86)/MySQL/MySQL Server 5.6/bin/mysqldump.exe -uroot -p123 --add-drop-database -B myposdb -r"+path);

[@GSoftknowledge]

Check the path manually if the file doesn't exist then put the correct path. .

[@yogitashewale9905]

I am getting error that java.io.IOException: cannot run program "C:/abc" : create process error =2 ,the system cannot find the path specified

[@GSoftknowledge]

What's inside the path?

[@naveedaltaf]

Dear! Can i modify the program in a way so it automatically take database backup after given time', i.e. in very 30, 60 or 90 minutes? Thanks in advance.

[@GSoftknowledge]

Yes you can do that too ..

[@naveedaltaf]

@@GSoftknowledge thanx for respond, could you please make a video to demonstrate it? TIA

[@GSoftknowledge]

@@naveedaltaf okay

[@naveedaltaf]

@@GSoftknowledge thanks so much man this would really help me in completing my project, thanks again for help.

[@abhaydeep205]

@@naveedaltaf have you done this ? I also want to backup time to time

[@islamaminebouchedjera1408]

Hii, this method doesn't work with MySQL 8.0, it needs administrator privileges. Does it only work with MySQL 5.0?

[@GSoftknowledge]

Yes.

[@islamaminebouchedjera1408]

@@GSoftknowledge Hii sir, thanks for your reply. I've installed MySQL 5.0, when I run mysqldump from CMD it works, but from java project it doesn't work!! Do you have any idea or suggestions?

[@neelmanithakur7760]

Hey man make a video on how we can export jar file in netbeans so that it will work with Default java Database that is default preasent in netbeans. its a serious Problem !!

[@GSoftknowledge]

I have already made a video on this...

[@GSoftknowledge]

kzbin.info/www/bejne/gqOpcpd6r5pqqKc