Apache OpenOffice Community Forum • I need backup Database button - (View topic)

Page 1 of 1

I need backup Database button

Posted: Sun Aug 09, 2015 9:15 pm

by ypersyntelykos

Hello

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

any help ??
thanks

Re: I need backup Database button

Posted: Sun Aug 09, 2015 9:20 pm

by Villeroy

Like 99% of Windows users you need a decent backup program to save all your work.

Re: I need backup Database button

Posted: Wed Aug 12, 2015 5:16 am

by DACM

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.
- - Tools > SQL...
    Code: Select all
```
SET FILES BACKUP INCREMENT FALSE
```