# Patching guide

#### App Patching
#### Step
1. login to the server
2. extract the content to root dir (C:\caddy\html) (use application like 7z for windows to extract).


#### DB Patching
#### Step
1. login to server
2. open terminal,
3. cd to mysql bin directory 
```
cd "C:\Program Files\MySQL\MySQL Server 8.0\bin"
```
4. login to the mysql server using (the password in C:\ in text file mysql_pass.txt)
```
mysql.exe -u root -p
```
5. drop the existing database
```
DROP DATABASE ukas;
```
6. create the database 
```
CREATE DATABASE ukas;
```
7. logout from mysql server
```
exit
```
8. import the new sql
```
mysql -u root -p ukas < path_to_sql_file.sql
```