Knowledgebase
Migrating a WordPress database Print this Article
-
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.
-
Go to myphpAdmin for the site.
-
Choose the DB in question.
-
Go to Export tab
-
Select “DROP TABLES”
-
Compression: zip (or no compression if it doesn’t work)
-
-
Open the database in notepad++:
-
search: utf8mb4_unicode_520_ci
-
replace with : utf8mb4_unicode_ci
-
-
Upload DB to root directory of site on Plesk
-
Download httpdocs/wp-config.php from file manager of site on Plesk
-
Go to Databases tab on Plesk
-
Select "Add Database"
-
Add DB name, username, and password. This information is found in wp-config that you previously opened. Use all defaults.
-
Go into new DB that was just created and select “Import Dump”
-
Choose the previously edited DB that you uploaded to the root directory.
-
Go into file manager on Plesk, and open wp-config
-
Change the value of DB_HOST to “localhost”
-
Go to the Wordpress tab on Plesk, and hit “scan”
Was this answer helpful?
Related Articles
Access your client portal at http://billing.dynamichosting.biz/. Navigate to My Products &...
Log in to your current hosting provider's control panel, and retrieve, or create FTP...
To create a new database on your hosting account: From the Websites & Domains tab, click...
Nameservers: ns21.dynamichosting.biz ns22.dynamichosting.biz
Securing your domain with an SSL certificate is not necessary, but it is recommended. Its...