Differences

This shows you the differences between two versions of the page.

--- guides:farming:upgradedb [2022/05/17 12:37] – [Download and replace] vleesbanaan
+++ guides:farming:upgradedb [2022/06/21 08:09] (current) – vleesbanaan
@@ Line 1: / Line 1: @@
 ===== How to Upgrade the Chia db =====
-Upgrading the Chia db CAN be a very simple process. Simply download a version of chia above 1.3.0+ and run ''chia db upgrade'' in CLI.
+Upgrading the Chia db from v1 to v2 CAN be a very simple process.
+However, the reason you are reading this guide is most probably because you want to learn how to upgrade AFTER your drive is full and you don't want to sync from scratch.
+We will go through three different ways:
+  - Upgrading the easy way
+  - Download v2 from a trusted source and replace v1
+  - Using an external SSD
+  - Using the SpaceFarmer Community Node
+==== 1. Updating the easy way ====
+  * in CLI change directory to chia ''cd c:\Users\%USERNAME%\AppData\Local\chia-blockchain\a*\resources\app.asar.unpacked\daemon\''
+  * run ''chia db upgrade'' in CLI.
+  * Update your config.yaml under the ''full_node:'' section from ''database_path: db/blockchain_v1_CHALLENGE.sqlite'' to ''database_path: db/blockchain_v2_CHALLENGE.sqlite''.
 There are two prerequisites for upgrading the Chia db the easy way.
   * enough space on the target directory
-  * enough space on your temporary directory
+  * enough space on your temporary directory (often overlooked)
-However, the reason you are reading this guide is most probably because you want to learn how to upgrade AFTER your drive is full and you don't want to sync from scratch.
+For further reference, see https://github.com/Chia-Network/chia-blockchain/wiki/FAQ#what-is-the-new-database.
-We will go through two different ways:
+==== 2. Download and replace ====
-  - download v2 from a trusted source and replace v1
-  - Using an external SSD
-==== Download and replace ====
 The advantage of this method is that it is easy and has minimal downtime. The trick is to download the db right after the snapshot, so your node needs to do minimal syncing to catch up with the latest blockheight. The downside is that you need to trust the source from which you download the snapshot.
-Make sure your TMP folder has enough space available (size of v1+v2). If not, see the fix under
   - Stop all chia processes
-  - go to DIRECTORY
+  - go to ''C:\Users\%USERNAME%\.chia\mainnet\db'' and delete ''blockchain_v1_mainnet.sqlite''
-  - delete the VERSION1DB
+  - download the v2 db from a source you trust and place it in the folder. Spacefarmers offers a daily snapshot [[guides/farming/downloaddb|here]]
-  - download trusted v2
+  - in your your config.yaml, replace under the ''full_node:'' section from ''database_path: db/blockchain_v1_CHALLENGE.sqlite'' to ''database_path: db/blockchain_v2_CHALLENGE.sqlite''
-  - edit config.yaml
+==== 3. Using an external SSD ====
-==== Using an external SSD ====
   * stop all chia processes ''chia stop all''
   * [[guides/farming/movedb|Move the chia db v1 to another folder]]
+  * Make sure your TMP folder has enough space available (size of v1+v2). If not, see the fix under "Error when TMP folder full".
   * in CLI change directory to chia ''cd c:\Users\%USERNAME%\AppData\Local\chia-blockchain\a*\resources\app.asar.unpacked\daemon\''
   * ''chia db upgrade''
-  * when done, ''chia start all'' and wait for it to sync
+  * in your your config.yaml, replace under the ''full_node:'' section from ''database_path: db/blockchain_v1_CHALLENGE.sqlite'' to ''database_path: db/blockchain_v2_CHALLENGE.sqlite''
-=== Error when TMP folder full ===
+  * when done, ''chia start farmer -r'' and wait for it to sync
-The method above doesn't work if your tMP folder (which is  ''C:\Users\%USERPROFILE%\Appdata\Local\Temp'' by default on Windows) is on the full drive.
+=== 3.1 Error when TMP folder full ===
+The method above doesn't work if your TMP folder (which is  ''C:\Users\%USERPROFILE%\Appdata\Local\Temp'' by default on Windows) is on the full drive.
 You will attempt to do so, you get a pop-up with the following window somewhere in the process:
@@ Line 51: / Line 64: @@
   * In case you already used ''chia db upgrade'', remove the blockchain_v2_mainnet.sqlite that was created in your target folder.
   * ''chia db upgrade''
+after you are done, don't forget to set back your temporary folder back to your original folder!
+==== 4. SpaceFarmer Community Node ====
+It is also possible to farm without running a full node locally. Using the hooks that already exist in Chia 1.3+, we created the [[poolinfo/join/communitynode|SpaceFarmer Community Node]] to allow farmers that cannot run their own node to continue farming.