Hi Balazs,
The easiest way to setup and online scheduled backup is via the “System Admin
-> Backup” tab of the Virtuoso Conductor where and initial Full backup can e
initiated and a scheduled backup interval can be specified for subsequent
incremental backups of the database to take place.
Bes
Hi Balazs,
Yes, a crash-dump and restore can always being performed to attempt recovery of
the database …
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.l
Just realized we can make checkpoint anytime too, so we should be able
to resolve the corrupt database with "crash_dump" without losing any
data, right?
On 17/09/15 10:47, Balazs Varhegyi wrote:
Hi,
We did an integrity check for the first time with " backup
'/dev/null'" and it stopped with:
Hi,
We did online backups manually following this procedure that we would
like to automate:
|"isql-vt dba dba"|
|"status();"|
|"checkpoint_interval(-1);"|||
|"checkpoint;"|
|"backup_online('virt-inc_dump_01082015#',100,0,vector('/usr/local/var/lib/virtuoso_backup'));"|
|"checkpoint_int
Hi Jyoti,
Virtuoso does not cache query result sets per say, but rather the databases
working set for a given query work load gets loaded into memory (cache) on
demand such that subsequent queries touching the same database working set
would not have to be read from disk. Thus the first time a
