StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Consult the gfix manual section <a href="http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-dbverify.html" rel="nofollow">Database Validation and Recovery</a>. </p> <blockquote> <h3>Full Validation</h3> <p>By default, validation works at page level. If no need to go deeper and validate at the record level as well, the command to do this is:</p> <pre><code>gfix -v[alidate] -full database_name </code></pre> <p>using this option will validate, report and update at both page and record level. Any corrupted structures etc will be fixed. </p> <p>[...]</p> <h2>Database Recovery</h2> <p>If the database validation described above produces no output then the database structures can be assumed to be valid. However, in the event that errors are reported, you may have to repair the database before it can be used again.</p> <h3>Recover a Corrupt Database</h3> <p>The option required to fix a corrupted database is the gfix -m[end] command. However, it cannot fix all problems and may result in a loss of data. It all depends on the level of corruption detected. The command is:</p> <p>gfix -m[end] database_name</p> <p>This causes the corruptions in data records to be ignored. While this sounds like a good thing, it is not. Subsequent database actions (such as taking a backup) will not include the corrupted records, leading to data loss.</p> <h2>Important</h2> <p>The best way to avoid data loss is to make sure that you have enough regular backups of your database and to regularly carry out test restorations. There is no point taking backups every night, for example, if they cannot be used when required. Test always and frequently.</p> <p>Equally, when attempting to recover a potentially corrupted database, always work with a copy of the main database file and never with the original. Using the -mend option can lead to silent deletions of data because gfix doesn't care about internal database constraints like foreign keys etc, the -mend option simply says to gfix "go ahead and clean out anything you don't like".</p> </blockquote> <p>These are the most important points of this section, but make sure to read the entire chapter. If you need additional support, on the Firebird-support list there are a number of people familiar with the ins and outs of Firebird and how to handle these kinds of errors.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload