@Tom-Elliott
to make a backup I use now sql in bash
root@fog:~# mysql -u root -N -B -e “USE fog; SELECT CONCAT(‘UPDATE hosts SET hostDevice = ‘’’, hostDevice, ‘’’ WHERE hostID = ', hostID, ‘;’)FROM hosts;” > restore_hostdevice.sql
and restore with
root@fog:~# mysql -u root fog < restore_hostdevice.sql