Hello, I’m working on moving my site from my old Ubuntu LTS server to a new one so that I can run Mysql 8, Ghost 5 and be stable for more years to come. This process was easy on my non member websites but it has proven to be a huge pain on member sites. To whit - the memberships get all messed up…

I recommend copying your database and Ghost files over verbatim to the new server. You can use a MySQL export/import process for the database. Then on the new server, use the Ghost CLI to use the official upgrade procedure. [image] Ghost Docs Everything you need to know about working w…

Thank you for that link. I’m working through this as the night goes on so will keep replying with more thoughts. The trouble is that I can’t update to ghost 5 on my ubuntu server without a bunch of work to get mysql 8 installed. So when I do a manual reinstall on the new server with the mysqldump…

Does this help? [image] How to Migrate From MariaDB 10 to MySQL 8 Installation This how-to will guide you through the steps to migrate from MariaDB 10 to MySQL 8. Ghost 5+ requires MySQL 8, as it’s a breaking change , so upgrade now if you’re running MariaDB. …

Thank you for the reply. What you layout here is basically what I’m trying to do with a couple of tweeks like reinstalling ghost on the new server. I’m going to start fresh this morning and do all the steps again to see if it works. My systems are: Current system: Debug Information: OS: Ubuntu…

Thank You, This is not the issue I’m experiencing. My difference is in paid members specifically. I’m missing paid members after the migration but have the same count of total subscribers, etc. I think the issue is that the paid members I’m missing all have at one point ended a subscription and …

I think I’d be inclined to clone the original server, do a dist-upgrade, and then update MySQL, Ghost etc. Once everything is hunky dory, I’d do it all again (essentially scripted), but put the original server under maintenance to prevent user changes, before updating DNS.

I finally got it to work. I’ll write up the process and make a new post for anyone that has this similar problem but I need to get on with the weekend with the family. Basic process is this: Export Mysql database with mysqldump Copy content/images from old host Export your theme from old install …

Same thing just happened with my member import. In order to upgrade to MySQL 8 on DigitalOcean, I had to create a new droplet and migrate everything over. On importing my members CSV, it lost six of my paid member’s subscriptions. I noticed one related issue/cause: in Ghost’s import dialogue, the “…

[image] brooklet: In order to upgrade to MySQL 8 on DigitalOcean, I had to create a new droplet and migrate everything over. Use snapshots, fire up a new droplet, upgrade to MySQL, and when things are working switch DNS to new IP. And, do a dry run first.

Errors in moving ghost site to new server

Developer help

markstos June 25, 2022, 11:06am 5

Could the difference you are seeing in your subscriber count have to do with unsubscribe-vs-deleted? Inconsistency between subscribers and send amount - #2 by David_Ramos

Topic		Replies	Views
Migrating Member Stats Self-hosting	13	303	May 7, 2024
Backup import has no metric data Self-hosting	2	317	April 20, 2022
How to Migrate From MariaDB 10 to MySQL 8 Installation	6	14415	September 3, 2023
Ghost migration error from 3.x to 5.x Bugs	4	769	November 22, 2022
Migrate ghost to another host Developer help	7	669	January 27, 2025

Errors in moving ghost site to new server

Related topics