Here' a process and products to use-

I assume that "redoing painting" your floors really means refinishing your hardwood floors with new stain + top coat. It would be helpful if you provide more details - type of wood/photos of current floor/what type of look you would like to achieve (for example, matte or satin)/etc.

The stain isn't what matters re: durability - it's the finish/top coat.

• Surface Hardness: Premium water-based urethanes dry to a harder finish, meaning they resist foot traffic abrasion and scratching very well on top of the wood.

• Flexibility and Dents: Oil-based finishes are softer and more elastic, meaning they absorb heavy impacts better and are slightly less prone to showing sharp dents.

• Scratch Visibility: Oil-based finishes tend to mask minor surface scuffs better as they wear down, whereas scratches on high-clarity water-based coats can sometimes show more visibly against the clear background.

• Color Retention: Water-based top coats dry completely clear and stay clear. Oil-based coats turn a warm amber color that deepens as it ages.

• Smell and Drying: Water-based formulas dry in 1 to 2 hours with low odors and low VOCs. Oil-based formulas take 10 to 12 hours to dry and emit strong fumes.

• Cost: High-end commercial-grade water-based products generally cost significantly more for materials than standard oil-based options.

The compatibility of the stain and finish does matter - you need to make sure that the person refinishing your floors is a knowledgeable professional.