If your web project uses a database, then most likely you are using MySQL - the vast majority of hosting providers today offer this particular DBMS to their customers. Let's look at the easiest way to upload a database to your server.
Instructions
Step 1
It is very difficult to find a provider who does not provide an application called phpMyAdmin as a MySQL control panel. It is designed to administer databases directly through a browser. To start the upload operation, find the "Databases" section in the hosting control panel, and in it a link to phpMyAdmin, open it and go to the database you need. There are usually several of them, the selection is carried out in the left panel of the interface.
Step 2
The next step in your actions to load the database on the server should be to prepare the table structure at the new data storage location. As a rule, text files containing MQL code instructions are used to transport data from one storage location to another. Depending on how this data was downloaded from its original storage location, all instructions may or may not have directives for creating data tables of contents at the beginning of all instructions. If there are no such directives there, then before loading you need to create tables yourself. This can be done using the phpMyAdmin interface. And if there is, the required table structure will be created during the loading process without your participation.
Step 3
Now you should make sure that the amount of downloaded data is within the limit set by your hosting provider. It is set in the PHP settings and is rarely less than two megabytes. As a rule, this is quite enough, but if your database is very large, then before uploading it will have to be split into several files that fit into the allowed size. Click the "Import" link and next to the "Browse" button you will see the maximum allowed weight of the downloaded file
Step 4
Once the file (or files) is ready for upload, click the Browse button and select the file you want.
Step 5
If your database contains texts in Russian, then make sure that their encoding matches the one specified in the "File encoding" window. If it does not match, select the required value in the drop-down list.
Step 6
The final action - click the "OK" button at the bottom of the page. If you had to split the database into several parts, repeat the import procedure for each file.
