Backup and restore help

[athenaxstories]

Is there a way to Just transfer my members and threads without themes and template data??

[.m.]

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

[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

[.m.]

at the new web host server :
you can create a new database, create a new user for the database,
add all privileges to the database AND import your database backup.

in general, phpMyAdmin is used at web host control panel.
database backup from previous server can be imported using phpMyAdmin

new database will have a different name, different user name & password
those details should be edited in config.php named file in inc folder

more details of config.php file => Link

[HLFadmin]

There may be limits established by webhost on backup sizes saved or imported.

An alternative is to backup using command line and ssh login via putty.
FTP to download and upload backups.

To create a backup from a command line:
mysqldump - h hostname -uusername -p databasename > backup.sql

To restore from the backup:
mysql -h hostname -u username -p databasename < backup.sql

Please note that a backup file created with phpMyAdmin will not restore without errors on mysql, and vice versa.