# How  to upgrade databases

**How to Upgrade Database**

**Follow these steps to update your database:**

* Taxido uses a **version-controlled system** to manage database changes. Each new version may include specific SQL queries to keep your database in sync with the latest codebase.
* After downloading the latest version from CodeCanyon, make sure to **execute the corresponding SQL file(s)** in your database to avoid any functionality issues or mismatches.
* All version-wise SQL update files are located in the following directory: `public/db`
* Run only the SQL files that correspond to the versions you are upgrading through. For example, if you are updating from v1.0.1 to v1.0.3, you must run both `v1.0.2.sql` and `v1.0.3.sql`.

<div align="left" data-full-width="false"><figure><img src="https://74030740-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6o4UzjBZtMQpeq4oeh8s%2Fuploads%2FwSDlPK9FszlJtCGHYRLE%2Fimage.png?alt=media&#x26;token=dd54d7b1-7c32-4847-8727-f8364e140562" alt=""><figcaption></figcaption></figure></div>

{% hint style="info" %} <mark style="color:blue;">**Note:**</mark>

<mark style="color:blue;">Before running any SQL queries,</mark> <mark style="color:blue;"></mark><mark style="color:blue;">**please take a full backup of your database**</mark><mark style="color:blue;">. Executing these queries may result in data loss if not done carefully.</mark>\
\ <mark style="color:blue;">These update guidelines are provided to help you integrate new versions with your existing source code smoothly.</mark>\
\ <mark style="color:blue;">**Please do not raise support tickets for issues that occur during this update process,**</mark> <mark style="color:blue;"></mark><mark style="color:blue;">as we are unable to provide assistance for manual update errors.</mark>
{% endhint %}