Differences

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

--- guides:farming:upgradedb [2022/05/17 12:52] – [How to Upgrade the Chia db] 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 from v1 to v2 The process of upgrading the Chia db CAN be a very simple process.
+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.
@@ Line 8: / Line 8: @@
   - Download v2 from a trusted source and replace v1
   - Using an external SSD
+  - Using the SpaceFarmer Community Node
-==== Updating the easy way ====
+==== 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\''
@@ Line 23: / Line 24: @@
 For further reference, see https://github.com/Chia-Network/chia-blockchain/wiki/FAQ#what-is-the-new-database.
-==== Download and replace ====
+==== 2. 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.
   - 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
-==== Using an external SSD ====
+==== 3. Using an external SSD ====
   * stop all chia processes ''chia stop all''
@@ Line 39: / Line 39: @@
   * 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''
+  * when done, ''chia start farmer -r'' and wait for it to sync
-=== Error when TMP folder full ===
+=== 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.
@@ Line 63: / 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.