Error restoring from backup
Brought to you by:
lbrueckner
Menu
▾
▴
I have been unable to perform a database restore in ibWebAdmin.
ibWebAdmin runs on the same server as the database I am connecting to. I have been able to perform a backup in ibWebAdmin successfully. However, when I attempt a restore from this backup, the following error syntax is displayed:
Result from extern command:
gbak: ERROR: could not drop database /var/lib/interbase/mydatabase.gdb (database might be in use)
gbak: Exiting before completion due to errors
I am certain that no other processes are connected to the database, with the notable exception of ibWebAdmin, of course.
Am I to assume that the reason I can't overwrite the database is because ibWedAdmin is connected to it? And if that is the case, how am I to get around this conflict?
You are right, you cannot restore a database while you are connected to it with ibWebAdmin. And I have not found a way to solve this in php.
There are two options you have: Choose another name for the target database or connect to another database than the one you want to restore.
One thing I could implement would be to enable restore without the necessary for logging in before. But I'm not sure about security issues, and you are the only one until now who is complaing about this.
Lutz
After I posted my original thread, it dawned on me that doing what I am asking would indeed be problematic in PHP.
Perhaps, as you suggest, you could enable the restore functionality without the need to log in beforehand, but only if a particular constant were set to TRUE in the configuration.inc.php file. This could place the burden of assessing the security risk on the web admin.
Just an idea.