If you have text files or files with the sql extension at your disposal, containing instructions for creating database tables and filling them (dump), then the easiest way is to upload it to the server using the phpMyAdmin application. It allows you to perform a huge number of operations with the MySQL DBMS directly in the browser.
Necessary
PhpMyAdmin application access
Instructions
Step 1
Find the "Databases" section in the hosting provider's control panel, link to phpMyAdmin in it and enter the application.
Step 2
As a rule, the dump does not contain instructions related to creating a database, but only to tables and their contents. Therefore, if the required database does not exist yet, create it, and if it already exists, click the corresponding link in the left frame of the interface.
Step 3
Then find the "Import" link in the right frame and click it. Next to the button labeled "Browse" is a number indicating the maximum size of uploaded files - usually two megabytes or more. If your dump files do not fit into this limit, then they will have to be split into several smaller ones.
Step 4
Having prepared the files, click the "Browse" button, which opens a standard file search and download dialog. Find and select the first of the dump files.
Step 5
In the drop-down list next to the "File encoding" label, select the character set that contains the national alphabet characters required to display the dump data. If your database does not use text fields or they all contain only English letters, then this operation is not important.
Step 6
When all this is done, click the "OK" button located at the very bottom of the right frame of the phpMyAdmin interface. If the dump is contained in several files, then the download operation must be repeated for each of them.
