To import a database, you can either import a database dump from Plesk or go to phpMyAdmin. phpMyAdmin is a software tool that allows you to manage a database online. For more information about phpMyAdmin see their page https://www.phpmyadmin.net/
Both options require that the database has already been created (Database creation) and that you offer the database in a .sql format so that the server can recognize it. Generally, exports of a database are offered in a .sql format.
Login on Plesk Control Panel
- In My Cloud86 (link), click in the left menu on My Services.
- Click the 3 dots behind the web hosting package you want to see in Plesk and click View Details.
- Under the heading Manage Webhosting (middle of the page), click on Websites & Domains.
- You will now be automatically logged into the Plesk Control Panel.
For the full manual with images, follow Login to Plesk
Database import via phpMyAdmin
Before you can import a database, you must first create it in the Plesk control panel with the existing data. So check the database name, username and password of your existing database properly, see also Database creation and Restoring a manual WordPress Backup.
- In Plesk, on the left menu, click Databases and locate the database where you want to import the files. At that database, click phpMyAdmin.
- In the new tab, click Import at the top, Choose File, and then without further changes, click the Import button at the bottom.
- The database import is now in progress in the background. Keep the page open until the import is finished. For large databases, you can upload the same file again to continue if it stopped halfway through. You can close the page when you see the following message: Import successful.
Database import via Dump
Before you can import a database, you must first create it in the Plesk control panel with the existing data. So check the database name, username and password of your existing database properly, see also Database creation and Restoring a manual WordPress Backup.
- In Plesk, click in the left menu on Databases and locate the database where you want to import the files. At that database, click Import Dump.
- Click Upload and select the .sql file you want to import. This can be done locally from your computer or from the Web Hosting Package. Then click OK to import the database. Note: by default, all tables are recreated, make sure you don't need any files from the original database.
If you need some help, you can always reach our support desk by email support@cloud86.io and on weekdays from 10:00 am to 4:00 pm you can also reach us by phone and via the chat in My Cloud86.