I need backup Database button

Discuss the database features

I need backup Database button

Postby ypersyntelykos » Sun Aug 09, 2015 9:15 pm


I need to create a button which make backup database in windows

any help ??
OpenOffice 4.1 + LibreOffice 5 on Windows Vista + XP
OpenOffice 4.1 + LibreOffice 5 on Linux mint 17,2
User avatar
Posts: 107
Joined: Tue Jul 28, 2015 6:31 pm

Re: I need backup Database button

Postby Villeroy » Sun Aug 09, 2015 9:20 pm

Like 99% of Windows users you need a decent backup program to save all your work.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Posts: 28670
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: I need backup Database button

Postby DACM » Wed Aug 12, 2015 5:16 am

See: Automated file backup upon closing the database: cloud folder versioning/history and other local options

Assuming HSQLDB...
    see also: Automating database backup during a session using CHECKPOINT DEFRAG command

    perhaps specifically: send CHECKPOINT DEFRAG using a macro assigned to a button on a Form

    In addition, HSQLDB 2.x users may need to initiate automatic backup as noted here and quoted below:
    4c. HSQLDB 2.x does not maintain a .backup file by default, so if you don't see this file in your database folder, then issue the following command using the Tools > SQL console in Base to initiate "full" backup upon CHECKPOINT or SHUTDOWN. You will notice "... INCREMENT FALSE" (below) which enables "full" backup as opposed to "incremental" backup. With very large databases (Gigabyte .data file size) "incremental" backups become necessary to minimize CHECKPOINT processing delays in demanding environments. Either backup mode is sufficient.

AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
User avatar
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am

Return to Base

Who is online

Users browsing this forum: No registered users and 0 guests