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
[mysqld]
innodb-read-only-compressed=OFF
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.
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
[client-server]
# 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/
[mysqld]
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
[mysql]
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