Re: [luciddb-users] Missing BACKUP_DATABASE/RESTORE_DATABASE routines?

[John V. S. <js...@gm...>]

Vassil Kovatchev wrote:
> Hi All,
> 
> Today I tried to backup my LucidDB 0.7.4 instance and to my surprise I 
> found out that the backup/restore routines were missing from the 
> SYS_ROOT schema.
> I ran the following SQL statement on sqllineClient:
> call SYS_ROOT.BACKUP_DATABASE('/usr/luciddb-0.7.4/catalog/full_archive', 
> 'FULL', 'COMPRESSED');
> ...which yielded the following message:
> Error: From line 1, column 15 to line 1, column 94: No match found for 
> function signature BACKUP_DATABASE(<CHARACTER>, <CHARACTER>, 
> <CHARACTER>) (state=,code=0)

BACKUP/RESTORE is not in the 0.7.4 release.  It is available for testing 
in the 0.7.5 prerelease:

http://perforce.eigenbase.org/download/luciddb-bin-linux32-0.7.5.tar.bz2
http://perforce.eigenbase.org/download/luciddb-bin-linux64-0.7.5.tar.bz2

JVS