Web design agency
StudioWEBER

How to Move WordPress Site Manually to New Host or Server

How to Move WordPress Site Manually to New Host or Server

How to Move WordPress Site Manually to New Host or Server in 6 Easy Steps

  1. Download site files via cPanel or FTP protocol from the old server or host
  2. Download the MySql database archive via phpMyAdmin form the old server or host
  3. Upload the site files to the new server or host
  4. Create a MySql database and user on the new server
  5. Upload the old MySql database archive via phpMyAdmin
  6. 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

How to perform Search and Replace in phpMyAdmin?

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

How to identify the TABLE_NAME and 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

Share

Previous Post