You can easily create MySQL databases in your localhost or hosting account. You might have seen SQL file when you buy premium theme or free theme package. You can see 'create database and import' steps in documentation. How to create database and import?
Localhost
If you don't have server or you want test/configure build in local system. You can install XAMP, XAMP is a free and open source cross-platform web server solution stack package.
- Start MySQL using XAMP control panel.
- Open browser and navigate to PHPMyAdmin (http://localhost/phpmyadmin/).
- Enter 'database name' and click 'create'.
- Click 'import' and browser database and click 'GO'.
You will get success message if successfully imported you database.
Hosting account
- Login with Cpanel account.
- Scroll down to 'Databases' section.
- Click 'MySQL' databases and Enter database name and create Database.
- Navigate back to Cpanel -> Databases section.
- Click PHPMyAdmin
- Choose the Database which you created
- Click 'Import' tab, Browse database and click 'Go'.
How to export Database
Exporting database is same for localhost or hosting account. Navigate to PHPMyAdmin select database which you want to export and click 'Export' tab and export database.