Backup and restore help

[athenaxstories]

MyBB's Stock theme is named as Default & its templates set is named Default Templates.

other themes & template sets are named similarly.
eg. Netpen theme & Netpen templates

at Themes section of forum admin panel,
you can delete a theme by using options button which appears next to theme name 

similarly a templates set can be deleted if the set is not used by a theme.

after deleting unnecessary themes & template sets, you can take
database backup & files backup to use at another web host server

i can take both database and files backup
i know how to upload mybb files to new host
how to upload sql tables ??
if i create new sql database and upload tables there it runs??
in my previous host the database name host password different from new host database names I need to change anything in newhost??
Help me 
Thanks