The best explanation for why the capital of South Carolina was moved from Charleston to Columbia is:
Charleston’s wealthy elite wanted to protect their property by moving inland.
This reason indicates a desire for safety and protection from potential threats, including attacks that could target a coastal city like Charleston, making it a practical choice to move the capital to a more secure inland location.