From 780b92ada9afcf1d58085a83a0b9e6bc982203d1 Mon Sep 17 00:00:00 2001 From: Lorry Tar Creator Date: Tue, 17 Feb 2015 17:25:57 +0000 Subject: Imported from /home/lorry/working-area/delta_berkeleydb/db-6.1.23.tar.gz. --- docs/installation/sqlite_ver61.html | 190 ++++++++++++++++++++++++++++++++++++ 1 file changed, 190 insertions(+) create mode 100644 docs/installation/sqlite_ver61.html (limited to 'docs/installation/sqlite_ver61.html') 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 @@ + + + + + + Updated SQLite Version + + + + + + + + +
+
+

Library Version 12.1.6.1

+
+ + + + + + + + + +
Updated SQLite Version
Prev Chapter 9.  Upgrading Berkeley DB 12.1.6.0 applications to Berkeley DB 12.1.6.1  Next
+
+
+
+
+
+
+

Updated SQLite Version

+
+
+
+
+
+
+ + Upgrading SQL databases to releases after 6.1.19 + +
+
+
+

+ 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 http://sqlite.org/changes.html for further + information. +

+
+
+
+
+

Upgrading SQL databases to releases after 6.1.19

+
+
+
+

+ 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. +

+
+
+
+
+

Upgrading SQL databases on POSIX/UNIX Systems

+
+
+
+

+ The shell script upgrade61.sh 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: +

+ 
sh db-x.x.xx/lang/sql/upgrade61.sh <db1.dbsql> <db2.dbsql> ...
+

+ The upgrade process can be done by hand by executing + the following commands for each database: +

+
+
    +
  1. +

    + Back up the database and shut down any + applications accessing it. +

    +
    2. +
  2. +

    + Run recovery on the database journal directory as follows: +

    + 
    db_recover -f -h <database-journal>
    +
    3. +
  3. +

    + Enter the dbsql shell and execute a SQL REINDEX + command as follows: +

    + 
    dbsql <database.dbsql>
+dbsql> REINDEX
+dbsql> .quit
    +
    4. +
+
+

+ That completes the upgrade process. +

+
+
+
+
+
+

Upgrading SQL databases on Windows Systems

+
+
+
+

+ 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: +

+ 
db-x.x.xx\lang\sql\upgrade61.bat <db1.dbsql> <db2.dbsql> ...
+

+ The upgrade process can be done by hand by executing + the following commands for each database: +

+
+
    +
  1. +

    + Back up the database and shut down any + applications accessing it. +

    +
    2. +
  2. +

    + Run recovery on the database journal directory as follows: +

    + 
    db_recover.exe -f -h <database-journal>
    +
    3. +
  3. +

    + Enter the dbsql shell and execute a SQL REINDEX + command as follows: +

    + 
    dbsql.exe <database.dbsql>
+dbsql> REINDEX
+dbsql> .quit
    +
    4. +
+
+

+ That completes the upgrade process. +

+
+
+
+
+
+ + + + + + + + + + + +
Prev  + Up +  Next
New Database Format for BLOBs  + Home +  Removed C# Class
+
+ + -- cgit v1.2.1