SQL Backup

I am totally new to SQL.
I have a php forum running right now. I always backup my SQL database from phpMyAdmin.
My question is:
Let’s say I want to create another forum and wish to install back the SQL database, Would all the messages, designs, CASH points earned by users and whatever be recovered?

That’s the idea. (To the same version/forum platform, of course).