Export pre 1.8 data from old database into new 1.8 database

Get Help
1

Hi, never used docker before, and just setup the latest version.

Would like to know if it’s possible to export the data from the pre 1.8 CMS and import that into 1.8 ?

2

Yes it is possible. It’s covered in the manual here:

https://xibo.org.uk/manual-tempel/en/upgrade_switch_to_docker.html

3

Hi Alex, thanks for your reply.

When i get to the mysql part to run commands it does not work.

mysql -h mysql -u cms -p cms
Returns nothing

Also if i just run the following instead:

mysql -u cms -p
ENTER PASSWORD:
USE CMS;
UPDATE setting SET value=“/var/www/cms/library/”, userSee=0, userChange=0 WHERE setting=“LIBRARY_LOCATION”;

This also does not return anything.

Any ideas? Using docker is very unfamiliar to me.

4

Okey so i re-did everything and followed the guide to the letter. I’m back at the mysql part when i ran the first row i get this:

ERROR 1146 (42S02): Table ‘cms.setting’ doesn’t exist

CLI i ran:

UPDATE setting SET value=“/var/www/cms/library/”, userSee=0, userChange=0 WHERE setting=“LIBRARY_LOCATION”;

5

Okey so i managed to follow the guide, it works now. But i did not get any data from the mysqldump. at all.