transfer to an other site.

Did you try this?

I'm sure if you tried a search of the forum posts & or had a look at the documentation pages you would get the help you need.

Briefly, log in to your online hosting account.
Create a database, the way you did on your test server, give the user all privileges.
Note the db password, db username & db host.

Import all the db tables of your local Drupal site. If you have not done that before, simply go to phpmyadmin & save the database file & then import it.

Use an FTP client, like Filezilla to import the Drupal folder to the root folder, in case your site will be at www.yoursite.com/drupal. If the Drupal site will be at www.yoursite.com, open the drupal folder in the FTP client, select ALL files & folders & drag & drop them into the root folder of your "active" server.

Once all the files have been uploaded, go to /sites/default/settings.php & edit the database settings, to make sure they match those of the database you created online.

After that, your site should be accessible. I hope I have not left out something ...