I’m trying to upgrade my hosted install (ovh) to a docker install (vps) but it doesn’t work.
I don’t have ssh access, so I can’t do a mysqldump, and phpmyadmin doesn’t export my database correctly (random filesize).
I tried to use the backup file from ovh (187Mb) and rename it to import.sql and I used mysqldumper to create a backup file (363Mb). With both I don’t even get to the login screen.
When I run the following commands:
UPDATE `setting` SET `value`="/var/www/cms/library/", userSee=0, userChange=0 WHERE `setting`="LIBRARY_LOCATION";
UPDATE `setting` SET `value`="tcp://cms-xmr:50001", userSee=0, userChange=0 WHERE `setting`="XMR_ADDRESS";
UPDATE `setting` SET `value`="Apache" WHERE `setting`="SENDFILE_MODE";
You need to start with a good backup, otherwise nothing is going to work out well.
I’d suggest using phpmyadmin to clear the log table, and if you don’t use proof of play stats, then also the stats table. That will resolve the majority of export issues.
To do so, run the following SQL via phpmyadmin:
TRUNCATE `log`;
and optionally
TRUNCATE `stat`;
Then export, and use that as your import.sql file.
You’ll need to also delete the imported database between tests - ie
docker-compose down
rm -rf shared/db
cp mybackup.sql shared/backup/import.sql
docker-compose up -d
I got the same size after multiple backups. (64mb).
I can now connect with my old login, but I still get an error.
The URL goes to www.URL.com/update and I get this