blob: bdd69cb7a78d6f70399866b0fef6041e3a923ec3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
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>
|
