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...
Securing your domain with an SSL certificate is not necessary, but it is recommended. Its...
Adding content to your website, whether it be files or pictures, doesnt need to be hard! You CAN...