ssh root@cld-db-test-04.cloud
cd /backup/BackupCaracalPrimaDellUpdate
mysql -u root -p < drop_epoxy_db_test.my
mysql -u root -p < recreate_caracal_db_test.my
./fill_in_tables_caracal_db_test.sh cld-db-test-04.cloud.pd.infn.it.09-03-2026

[root@cld-db-test-04 BackupCaracalPrimaDellUpdate]# cat drop_epoxy_db_test.my 
drop database calendarpanel;
drop database horizon_aai;
drop database cinder;
drop database glance;
drop database heat;
drop database keystone;
drop database neutron;
drop database nova;
drop database nova_api;
drop database nova_cell0;
drop database placement;

[root@cld-db-test-04 BackupCaracalPrimaDellUpdate]# cat recreate_caracal_db_test.my 
create database calendarpanel;
create database horizon_aai;
create database cinder;
create database glance;
create database heat;
create database keystone;
create database neutron;
create database nova;
create database nova_api;
create database nova_cell0;
create database placement;

if [ -z "$1" ]; then
    echo "Errore: passare il nome del backup"
    exit 1
fi

echo "nome = $1"

echo "----  CALENDARPANEL  ----"
gunzip calendarpanel.$1.gz
mysql -u root -p  calendarpanel < calendarpanel.$1
gzip calendarpanel.$1
echo "------------"
echo "----  HORIZON_AAI  ----"
gunzip horizon_aai.$1.gz
mysql -u root -p  horizon_aai < horizon_aai.$1
gzip horizon_aai.$1
echo "------------"
echo "----  CINDER ----"
gunzip cinder.$1.gz
mysql -u root -p cinder < cinder.$1
gzip cinder.$1
echo "-------"
echo "----  GLANCE ----"
gunzip glance.$1.gz
mysql -u root -p glance < glance.$1
gzip glance.$1
echo "------------"
echo "----  HEAT ----"
gunzip heat.$1.gz
mysql -u root -p heat < heat.$1
gzip heat.$1
echo "------------"
echo "----  KEYSTONE ----"
gunzip keystone.$1.gz
mysql -u root -p keystone < keystone.$1
gzip keystone.$1
echo "------------"
echo "----  NEUTRON ----"
gunzip neutron.$1.gz
mysql -u root -p neutron < neutron.$1
gzip neutron.$1
echo "------------"
echo "----  NOVA ----"
gunzip nova.$1.gz
mysql -u root -p nova < nova.$1
gzip nova.$1
echo "------------"
echo "----  NOVA_API ----"
gunzip nova_api.$1.gz
mysql -u root -p nova_api < nova_api.$1
gzip nova_api.$1
echo "------------"
echo "----  NOVA_CELL0 ----"
gunzip nova_cell0.$1.gz
mysql -u root -p nova_cell0 < nova_cell0.$1
gzip nova_cell0.$1
echo "------------"
echo "----  PLACEMENT ----"
gunzip placement.$1.gz
mysql -u root -p placement < placement.$1
gzip placement.$1
echo "------------"