Table 'tabDefaultValue' missing in the restored site .

When I’m Trying to restore I’m getting this below error. please check

Your site will be downgraded from Frappe 13.58.3 to 13.56.4

This is not recommended and may lead to unexpected behaviour. Do you want to continue anyway? [y/N]: y

MySQL root password:

ERROR 2006 (HY000) at line 10236: MySQL server has gone away
Table 'tabDefaultValue' missing in the restored site. Database not installed correctly, 
this can due to lack of permission, or that the database name exists.
Check your mysql root password, validity of the backup file or use --force to reinstall
1 Like

sudo nano /etc/mysql/my.cnf



sudo service mysql restart

I’m using docker. what i do should i inspect the container?

After Downgrading 13.58.3 to 13.56.4. It’s again showing me to downgrade to 13.51.2 This is getting headache. Please help me to find out

After running this command I’m getting this error

Failed to restart mysql.service: Unit mysql.service not found.

Don’t know in docker.

I got a reference from here Click Here

Here they are telling how to do in bare metal which means non-docker if you are running the project in docker.

step 1
Get inside the Mariadb container

docker exec -it <CONTAINER_ID> bash

Step 2
update and install the nano

apt update
apt install nano

Step 3
Inspect the my.cnf file

nano /etc/mysql/my.cnf 

Edit the my.cnf file like this

# Port or socket location where to connect
# port = 3306
socket = /run/mysqld/mysqld.sock

# Import all .cnf files from configuration directory

!includedir /etc/mysql/mariadb.conf.d/
!includedir /etc/mysql/conf.d/

character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
innodb_read_only_compressed = FALSE
wait_timeout = 28800
max_allowed_packet = 128M

default-character-set = utf8mb4
net_buffer_length = 512M
debug-info = TRUE

and save the my.cnf file

Step 4
Restart the container

docker restart <CONTAINER_ID>

After that you can restore the db It will work thank you

1 Like