You've made the decision to start weight training again, and this time it's going to be different, you're not quitting. How can you make sure of that?
Build a habit not a chore. This phased approach can help:
Phase 1: Build the habit
Phase 2: Build a routine
Phase 3+: Progressive Overload
Phase 1: Build the habit
Phase 1 is building a habit, nothing else.
Start at home, just 1 bodyweight exercise between 1-3 sets max.
Keep it small, but do it daily. Do not skip a day, repetition and consistency are key to creating habit. Scaling back and doing less in a day is fine, skipping a day is not. Rest days are not needed since the workouts are light.
This phase should last 1-2 months, or until you notice progress. You will either start looking better, feeling stronger, or feeling better overall. This progress will keep you motivated.
Phase 2: Build a Routine
Phase 2 is the transition, at this point you've built the habit but you still want to avoid. Stick to 2-3 exercises at 3 sets max.
Now it's time to get organized and create a routine. You can look up routines online, hire a trainer for more personalized routines, or if your comfortable, build your own.
The workouts should feel more intense, but you don't want to start progressive overloading just yet. Stick to the same routine for at least 1 month.
Phase 3+: Progressive Overload
Now that you've built a proper foundation you can start progressively overloading.
Take the routine you've built in phase 2 and slowly add more intensity every 1-2 weeks. This can mean more reps, more weight, more sets, or more exercises.
Although this is not the most optimal or the most appealing way to start, it helps ensure consistency. Doing something consistently for 6 months will always be better than going hard for 3.