Migrate and Setup Hosted Live WordPress Site to Localhost

Step 1 : Download WordPress Files via File Manager / FTP

Step 2 : Export Live Website Database

Step 3 : Create New Database and Import

Step 4 : Replace Live Site Url with Local Site URL in database

UPDATE wp_options SET option_value = replace(option_value, 'https://blog.luxe.ru', 'http://localhost:88') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = replace(post_content, 'https://blog.luxe.ru', 'http://localhost:88');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'https://blog.luxe.ru','http://localhost:88');


UPDATE wp_options SET option_value = replace(option_value, 'http://blog.luxe.ru', 'http://localhost:88') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = replace(post_content, 'http://blog.luxe.ru', 'http://localhost:88');
UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://blog.luxe.ru','http://localhost:88');

Step 5 : Host WordPress Files to Local Server

Step 6 :Configure database changes in wp-config.php

// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'your_local_db_name);

/** MySQL database username */
define('DB_USER', 'your_local_user');

/** MySQL database password */
define('DB_PASSWORD', 'password');

/** MySQL hostname */
define('DB_HOST', 'localhost');

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');

Last updated