₦airaland Forum

I am perplexed as to why your DB would be at 45GB, how many subscribers do you have? 1 million?
What you need is an experienced backend enigneer [and yes, i said engineer, not developer] into microservices architectures. You should have ochestrated out your media/assets to a third-party storage like Google CLoud Bucket or Amazon S3 and only save the resource URL referencing your assets in your DB
That way, size would reduce drastically by almost 95%. You have a bigger problem more than the migration itself, which you should look into, as I am leaning towards the fact that you are saving raw assets into your database, VERY UNCOOL !!

Imagine how long it would take to download and upload 45GB twice . . 90GB, and extrapolating, for a few years, your DB size would run into 10TB or more. Hmmn.

As for the migration, if your'e still using the same driver, all it takes is a DUMP and RESTORE, nothing changes , except of course you changed the Model structures. In that case, then you must write an automation script to map existing fields to their corresponding new field names. and make it loop through 45GB of data. Hehehe.

Do you have at least 200k for a job well done, else it will "end in tears" ?

^^ Hell yea, u can say that again.