How to Move WordPress Site Manually to New Host or Server in 6 Easy Steps
- Download site files via cPanel or FTP protocol from the old server or host
- Download the MySql database archive via phpMyAdmin form the old server or host
- Upload the site files to the new server or host
- Create a MySql database and user on the new server
- Upload the old MySql database archive via phpMyAdmin
- Search and Replace the old url with the new one in phpMyAdmin:
How to perform Search and Replace in phpMyAdmin?
- Select the database for the wp site
- Click “Search” on the top menu bar
- Enter the old url, select all the tables and click “Go” button on the bottom right hand side
- In the search results identify the tables that contain the old url
See related post here: https://bobcares.com/blog/find-and-replace-in-phpmyadmin/
How to identify the TABLE_NAME and the FIELD_NAME?
- Click “Browse” next to the desired table that you want to perform search/replace on – open it in a new tab
- Search for the old domain here CTRL+F see where it shows and that column is the FIELD_NAME
- The TABLE_NAME is listed in the search result above (ex: “peuengi_posts”)
- Click “SQL” on the top menu bar and open it in a new tab
- Copy/paste this line of code
update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, 'Text to find', 'text to replace with');
- Replace TABLE_NAME and FIELD_NAME with the corresponding values for each table
- Click “Go” – bottom right
- Repeat for all the tables found in the search results.
See a complete tutorial here: https://www.youtube.com/watch?v=eO2TpFED3EE