diff options
Diffstat (limited to 'docs/installation/sqlite_ver61.html')
-rw-r--r-- | docs/installation/sqlite_ver61.html | 190 |
1 files changed, 190 insertions, 0 deletions
diff --git a/docs/installation/sqlite_ver61.html b/docs/installation/sqlite_ver61.html new file mode 100644 index 00000000..bdd69cb7 --- /dev/null +++ b/docs/installation/sqlite_ver61.html @@ -0,0 +1,190 @@ +<?xml version="1.0" encoding="UTF-8" standalone="no"?> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> + <head> + <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> + <title>Updated SQLite Version</title> + <link rel="stylesheet" href="gettingStarted.css" type="text/css" /> + <meta name="generator" content="DocBook XSL Stylesheets V1.73.2" /> + <link rel="start" href="index.html" title="Berkeley DB Installation and Build Guide" /> + <link rel="up" href="upgrade_61_toc.html" title="Chapter 9. Upgrading Berkeley DB 12.1.6.0 applications to Berkeley DB 12.1.6.1" /> + <link rel="prev" href="blobdb_format.html" title="New Database Format for BLOBs" /> + <link rel="next" href="remlockdetect.html" title="Removed C# Class" /> + </head> + <body> + <div xmlns="" class="navheader"> + <div class="libver"> + <p>Library Version 12.1.6.1</p> + </div> + <table width="100%" summary="Navigation header"> + <tr> + <th colspan="3" align="center">Updated SQLite Version</th> + </tr> + <tr> + <td width="20%" align="left"><a accesskey="p" href="blobdb_format.html">Prev</a> </td> + <th width="60%" align="center">Chapter 9. Upgrading Berkeley DB 12.1.6.0 applications to Berkeley DB 12.1.6.1 </th> + <td width="20%" align="right"> <a accesskey="n" href="remlockdetect.html">Next</a></td> + </tr> + </table> + <hr /> + </div> + <div class="sect1" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h2 class="title" style="clear: both"><a id="sqlite_ver61"></a>Updated SQLite Version</h2> + </div> + </div> + </div> + <div class="toc"> + <dl> + <dt> + <span class="sect2"> + <a href="sqlite_ver61.html#sqlite_db_upgrade_61">Upgrading SQL databases to releases after 6.1.19</a> + </span> + </dt> + </dl> + </div> + <p> + Berkeley DB's SQL interface includes code from SQLite. + The version of SQLite used has been upgraded, so that + Berkeley DB SQL is now compatible with SQLite version + 3.8.3.1. Please see the release notes at <a class="ulink" href="http://sqlite.org/changes.html" target="_top">http://sqlite.org/changes.html</a> for further + information. + </p> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h3 class="title"><a id="sqlite_db_upgrade_61"></a>Upgrading SQL databases to releases after 6.1.19</h3> + </div> + </div> + </div> + <p> + When upgrading from Berkeley DB releases between 5.0 and + 6.1.19 to a release after 6.1.19, you must re-index any SQL + databases. Non-SQL databases do not require any action. + </p> + <div class="sect3" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h4 class="title"><a id="sqlite_db_upgrade_posix"></a>Upgrading SQL databases on POSIX/UNIX Systems</h4> + </div> + </div> + </div> + <p> + The shell script <code class="literal">upgrade61.sh</code> has + been provided to simplify upgrading. Before executing + the script, back up all the databases and shut down any + applications that access the databases. Then execute + the script, passing the path to one or more databases + in the command line, as follows: + </p> + <pre class="programlisting">sh db-x.x.xx/lang/sql/upgrade61.sh <db1.dbsql> <db2.dbsql> ...</pre> + <p> + The upgrade process can be done by hand by executing + the following commands for each database: + </p> + <div class="orderedlist"> + <ol type="1"> + <li> + <p> + Back up the database and shut down any + applications accessing it. + </p> + </li> + <li> + <p> + Run recovery on the database journal directory as follows: + </p> + <pre class="programlisting">db_recover -f -h <database-journal></pre> + </li> + <li> + <p> + Enter the dbsql shell and execute a SQL REINDEX + command as follows: + </p> + <pre class="programlisting">dbsql <database.dbsql> +dbsql> REINDEX +dbsql> .quit </pre> + </li> + </ol> + </div> + <p> + That completes the upgrade process. + </p> + </div> + <div class="sect3" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h4 class="title"><a id="sqlite_db_upgrade_win"></a>Upgrading SQL databases on Windows Systems</h4> + </div> + </div> + </div> + <p> + The batch script "upgrade61.bat" has been provided to + simplify upgrading. Before executing the script, back + up all the databases and shut down any applications + that access the databases. Then execute the script, + passing the path to one or more databases in the + command line, as follows: + </p> + <pre class="programlisting">db-x.x.xx\lang\sql\upgrade61.bat <db1.dbsql> <db2.dbsql> ...</pre> + <p> + The upgrade process can be done by hand by executing + the following commands for each database: + </p> + <div class="orderedlist"> + <ol type="1"> + <li> + <p> + Back up the database and shut down any + applications accessing it. + </p> + </li> + <li> + <p> + Run recovery on the database journal directory as follows: + </p> + <pre class="programlisting">db_recover.exe -f -h <database-journal></pre> + </li> + <li> + <p> + Enter the dbsql shell and execute a SQL REINDEX + command as follows: + </p> + <pre class="programlisting">dbsql.exe <database.dbsql> +dbsql> REINDEX +dbsql> .quit </pre> + </li> + </ol> + </div> + <p> + That completes the upgrade process. + </p> + </div> + </div> + </div> + <div class="navfooter"> + <hr /> + <table width="100%" summary="Navigation footer"> + <tr> + <td width="40%" align="left"><a accesskey="p" href="blobdb_format.html">Prev</a> </td> + <td width="20%" align="center"> + <a accesskey="u" href="upgrade_61_toc.html">Up</a> + </td> + <td width="40%" align="right"> <a accesskey="n" href="remlockdetect.html">Next</a></td> + </tr> + <tr> + <td width="40%" align="left" valign="top">New Database Format for BLOBs </td> + <td width="20%" align="center"> + <a accesskey="h" href="index.html">Home</a> + </td> + <td width="40%" align="right" valign="top"> Removed C# Class</td> + </tr> + </table> + </div> + </body> +</html> |