...
Code Block |
---|
docker cp database:dump.sql dump.sql |
Change the table names and columns and maybe the admin password…
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:
...
The modification only consists in the addition of lines 13 and 17.
Then, for each device insertion, make sure to add a NULL
value at the end.
Note |
---|
Careful, the |
Warning |
---|
For some reasons, the default admin password in the dump file is the same as the dev user. Please replace it by correct value. |
Loading the old database content into the new one
...