For each webhosting is available phpMyAdmin, which allows you to manage MySQL databases (tables and work with their data, export or import, and more).
Export of database
First, after logging in to phpMyAdmin, select the appropriate database, which requires export (backup) of the original or the current MySQL server.
After selecting the appropriate database, select in the top menu Export set these options:
- Tables: Select all
- Export type: Custom – display all possible options
- Output: Save to file
- Format: SQL
Other items leave the default and press Go.
Next, you are prompted to save the file *.sql into your computer. When complete, export of the original database (backup) is complete.
Import of database
First, after logging into the application phpMyAdmin choose the database to which you want to import tables from the original or current MySQL server.
After selecting the appropriate database, select in the top menu Import and select the *.sql file from the previous step (export). Always it must be the import of database tables only. In the imported file can not be multiple databases or commands for creating databases (only contain the structure and data tables).
All values leave the default setting and press Go.
At this point, it is necessary to wait until the import is done. It is depending on the speed of your Internet connection and the volume of imported data.
The result about successfull import look like this: