When you move your website to the hosting platform, most frequently, you also need to move your databases. This is done manually, in several stages:
1. First, download the database dump from the previous website hosting location. Find the phpMyAdmin section where your website is located now. If you are not sure where to look for it, ask the hosting support team.
After going there, select the database in the list on the left and go to the “Export” tab. Be sure to select the database first by pressing it in the list on the left and then starting the export. Complete the export with standard settings. The .sql file will start downloading in the browser. This file is called a database dump.
2. To move the database to a new location, upload the dump to the new website hosting location. First, create a new database for it.
- In the cPanel, go to MySQL database to create a new database. In the first form, specify the database name and press “Create database”. In the section below (Add new user) enter your username and password. Copy the password, you will need it to connect the engine to the database. In the lowest section, link the newly created user to the database and assign this user all the rights needed to work with it.
- In ISPmanager, go to the “Databases” section” and press “Add” to create a database. In the form, enter the database name, username and password.
- In BrainyCP, create a database in the “MySQL Database” section. The database is created by analogy with cPanel – you only need to create a user, a database and give the user rights to work with the database.
3. When the database is created, go to phpMyAdmin on our hosting and import a database. Select a database created during the second step in the list on the left, go to the “Import” tab and download a dump with standard settings.
If an error occurs at some stage, make a screenshot and contact support, and we will help you fix the issue.