...

Then dump the content of users, sm_devices and sm_device_models SMDevices and SMDeviceModels tables:

mysqldump -u root -p --single-transaction sambackend users sm_devices sm_device_modelsSMDevices SMDeviceModels > dump.sql

You will then be prompter to enter the root password to access the database.

...

docker cp database:dump.sql dump.sql

Change the table names

Some tables have been renamed when moving to the new version of the product. In particular SMDevices changed into sm_devices and SMDeviceModels changed into sm_device_models. The dump.sql file need to be updated to reflect that change. This can be done either manually using a proper file editor or with some Linux-style commands such as:

sed -i 's/SMDevices/sm_devices/g' dump.sql
sed -i 's/SMDeviceModels/sm_device_models/g' dump.sql

Loading the old database content into the new one

First push the file into the newer instance of the database container:

docker cp dump.sql database:dump.sql

Then load the content into the database:

mysql -u root -p sambackend < dump.sql