Migrating a WordPress database  Print this Article

  1. Check httpdocs for the site, and make sure that index.php exists, and not index.html. Rename index.html, to index.html.bak if need be.

  2. Go to myphpAdmin for the site. 

  3. Choose the DB in question. 

  1. Go to Export tab 

    1. Select “DROP TABLES” 

    2. Compression: zip (or no compression if it doesn’t work) 

  1. Open the database in notepad++: 

    1. search: utf8mb4_unicode_520_ci 

    2. replace with : utf8mb4_unicode_ci  

  2. Upload DB to root directory of site on Plesk  

  1. Download httpdocs/wp-config.php from file manager of site on Plesk  

  2. Go to Databases tab on Plesk 

  3. Select "Add Database"

  1. Add DB name, username, and password. This information is found in wp-config that you previously opened. Use all defaults. 

  1. Go into new DB that was just created and select “Import Dump” 

  2. Choose the previously edited DB that you uploaded to the root directory. 

  1. Go into file manager on Plesk, and open wp-config 

  2. Change the value of DB_HOST to “localhost 

  1. Go to the Wordpress tab on Plesk, and hit “scan”



Was this answer helpful?

Related Articles

Logging In To Plesk
Access your client portal at Navigate to My Products &...
Migrating Your Existing Site From Your Previous Host to Us
Log in to your current hosting provider's control panel, and retrieve, or create FTP...
Create a Database
To create a new database on your hosting account: From the Websites & Domains tab, click...
Securing your domain with an SSL certificate from Lets Encrypt
Securing your domain with an SSL certificate is not necessary, but it is recommended.  Its...
How to upload files with FTP
Adding content to your website, whether it be files or pictures, doesnt need to be hard! You CAN...