Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Documentation for NBACKUP is wrong about database replacement on restore [DOC25] #34

Closed
firebird-automations opened this issue Jan 17, 2007 · 14 comments

Comments

@firebird-automations
Copy link

Submitted by: Oliver Grenz (olivergrenz)

hello community,

I want to make a full restore of a database backup with the following command and I get always the same error code regardless what I do (The database I want to restore does already exists, the backup database is a full backup done with nbackup with the option B 0):

#⁠ /opt/firebird/bin/nbackup -U sysdba -P secret -R /usr/Inhouse/database.fdb /home/oliver/Backup/database.bak

#⁠ Failure: Error (17) creating database file :/usr/Inhouse/databse.fdb

What is going wrong? The directory is full writeable/readable (777), the database is owned by firebird.firebird with only read/write rights for this owner (rw-------). Must the database be closed with gfix? Is it a problem of rights?

Sincerly
Oliver Grenz

@firebird-automations
Copy link
Author

Commented by: Malte Tuellmann (malte)

the same behavior on Windows XP
if the destination - DB not exists -R woks fine, otherwise
Failure: Error (80) creating database file (...) via copying from (...)

regards

Malte

@firebird-automations
Copy link
Author

Commented by: Sean Leyne (seanleyne)

NBackup does not support overwriting the destination database. This is a "as designed" feature.

@firebird-automations
Copy link
Author

Modified by: Sean Leyne (seanleyne)

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Author

Commented by: Malte Tuellmann (malte)

o.k., the docs are wrong:

http://www.firebirdsql.org/manual/nbackup-backups.html

Restoring a full backup
[...]
"If the specified database already exists and there are no connections, it will be overwritten without any warning!"

@firebird-automations
Copy link
Author

Modified by: @pcisar

priority: Major [ 3 ] => Minor [ 4 ]

Component: Documentation [ 10011 ]

summary: Failure: Error (17) creating database file => Documentation for NBACKUP is wrong about database replacement on restore

@firebird-automations
Copy link
Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Author

Commented by: Andreas Kallenbach (andreas_kc)

Why is this issue closed? I just ran into this problem in testing TODAY and clearly there is an issue to be fixed.

The documentation could be corrected where it states nbackup is designed to restore a database and "If the specified database already exists and there are no connections, it will be overwritten without any warning!"

Otherwise the program could be corrected to agree with the documentation!

@firebird-automations
Copy link
Author

Modified by: @dyemanov

Project: Firebird Core [ 10000 ] => Documentation [ 10005 ]

Key: CORE1096 => DOC25

Version: 2.0.0 [ 10091 ] =>

Component: NBACKUP [ 10007 ] =>

Component: Documentation [ 10011 ] =>

@firebird-automations
Copy link
Author

Commented by: @helebor

Amazing! I don't know how it got closed.

I will check the release notes as to whether the same mistake is there and post an update here if it is.-- Helen

@firebird-automations
Copy link
Author

Modified by: @helebor

status: Closed [ 6 ] => Reopened [ 4 ]

assignee: Paul Vinkenoog [ paulvink ]

resolution: Won't Fix [ 2 ] =>

@firebird-automations
Copy link
Author

Commented by: @paulvink

I'm correcting and updating the nbackup doc now. Will upload the new HTML and PDF today.

Paul

@firebird-automations
Copy link
Author

Commented by: @paulvink

Documentation corrected.

@firebird-automations
Copy link
Author

Modified by: @paulvink

status: Reopened [ 4 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Author

Modified by: @paulvink

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants