db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suresh Thalamati <suresh.thalam...@gmail.com>
Subject Re: [jira] Commented: (DERBY-304) If by mistake you give he location for the db backup as the db itself , then windows created directories recursively until windows crashes!
Date Wed, 08 Feb 2006 01:07:07 GMT
Thanks Jeff, I agree with you, By making the list of all the contents 
of the database that need to go into the backup before creating backup 
directory will  avoid the backup copying onto itself  and going into 
end less recursion

After my recent online backup changes, only the jar directory really 
uses recursive copy of directories because it has sub directories with 
schema names. One could just find the contents of this directory 
before creating the backup directory.  And also just copy only files 
with "jar" suffix that are created by the database engine in the sub 
directories and ignore the user created files with any other 
extensions in these directories.

I was hoping to find out some sure way to prevent users creating 
backup in the database directories, looks like there is not one 
without enforcing some special Security Permissions. Hopefully
with GRANT/REVOKE feature , an administrator of the database can
limit the users who can execute backup procedures.


Jeffrey Lichtman wrote:
> I haven't been following this thread very closely, so please forgive me 
> if this has already been considered. I assume the problem is that the 
> backup algorithm creates a directory to contain the backup, so if the 
> location of the backup is in the database it tries to copy the contents 
> of the backup into itself.
> Would it work to make a list of the contents of the database before 
> creating the backup directory, and then make the algorithm work off the 
> list? I suppose it would be better to keep the user from putting the 
> backup in the database, but that isn't always easy to prevent.
>                        -        Jeff Lichtman
>                                 swazoo@rcn.com
>                                 Check out Swazoo Koolak's Web Jukebox at
>                                 http://swazoo.com/

View raw message