Help! All users have disappeared after migrating Pixelfed from one server to another

[jdaviescoates]

I thought I'd successfully migrated my Pixelfed app from one server to another, but when I actually tried to login, I couldn't.

Looking at https://bridport.pics/site/about it says:

0 people have shared 58 photos and videos on Pixelfed!

And when I do:

sudo -u www-data php artisan user:table
+----+----------+------+------------+
| ID | Username | Name | Registered |
+----+----------+------+------------+

I can see there are no users.

For some reason the backup/ import process has lost all the users!

Luckily I still have the app on the old server! Running the same sudo -u www-data php artisan user:table command there successfully shows the (thankfully only) 5 users that should be there.

Something is not right. Please help me to get this sorted.

[jdaviescoates]

@girish aftering giving both redis and the app a load more memory the import worked fine. I don't know why I didn't just try that before to be honest.

I'm not sure how it managed to half-work before so that the apps was running and the import seemed to have worked, but without the users, but I've just done the back import again and the users have re-appeared, so panic over. Phew.

[jdaviescoates]

@staff I think there is something worrisomely wrong with Pixelfed backups in that they don't seem to include anything about the users. I've no idea what to do about this.

[girish]

I can't reproduce this. All your are doing is backup and import the same backup into another server correct ? What happens if you clone from that backup in the other server, does that show the users?

[jdaviescoates]

@girish said in Help! All users have disappeared after migrating Pixelfed from one server to another:

What happens if you clone from that backup in the other server, does that show the users?

Testing now...

[jdaviescoates]

Well, the clone I made on the same server seems to work fine (after failing lots of times due to running out of memory and redis not starting properly etc, but it worked eventually after giving both the app and associated redis loads more memory).

I guess now I'll just try importing it again to the new server. But something just went wrong during the import...

[girish]

@jdaviescoates If it fails, would be good to have logs, after you start the import

[jdaviescoates]

@girish aftering giving both redis and the app a load more memory the import worked fine. I don't know why I didn't just try that before to be honest.

I'm not sure how it managed to half-work before so that the apps was running and the import seemed to have worked, but without the users, but I've just done the back import again and the users have re-appeared, so panic over. Phew.