Differences

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

--- guides:farming:upgradedb [2022/05/17 12:39] – vleesbanaan
+++ guides:farming:upgradedb [2022/05/18 06:10] – 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
+==== 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:
-  - download v2 from a trusted source and replace v1
-  - Using an external SSD
 ==== Download and replace ====
@@ Line 17: / Line 27: @@
   - 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 ====
@@ Line 29: / Line 38: @@
   * 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 ===
 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 52: / Line 63: @@
   * 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!