Migration between environments in Wordpress - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to export the WordPress database using WP-CLI.

Wordpress

wp db export [1].sql

Drag options to blanks, or click blank then click option'

Asave

Bexport

Cdump

Dbackup

Attempts:

3 left

💡 Hint

Common Mistakes

Using command names instead of file names.

Including file extensions in the option.

The command wp db export backup.sql exports the database to a file named backup.sql.

2fill in blank

medium

Complete the command to import a database dump into WordPress using WP-CLI.

Wordpress

wp db import [1].sql

Drag options to blanks, or click blank then click option'

Adatabase

Bdump

Cbackup

Dimport

Attempts:

3 left

💡 Hint

Common Mistakes

Using command names instead of file names.

Forgetting the .sql extension.

The command wp db import backup.sql imports the database from the file backup.sql.

3fill in blank

hard

Fix the error in the WP-CLI command to search and replace URLs during migration.

Wordpress

wp search-replace '[1]' '[2]' --skip-columns=guid

Drag options to blanks, or click blank then click option'

Ahttp://oldsite

Bhttp://newsite.com

Chttp://newsite

Dhttp://oldsite.com

Attempts:

3 left

💡 Hint

Common Mistakes

Swapping old and new URLs.

Omitting the protocol (http:// or https://).

The first argument should be the old URL to replace it with the new URL.

4fill in blank

hard

Fill both blanks to correctly update URLs during migration using WP-CLI.

Wordpress

wp search-replace '[1]' '[2]' --skip-columns=[3]

Drag options to blanks, or click blank then click option'

Ahttp://oldsite.com

Bhttp://newsite.com

Cguid

Durl

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect column names to skip.

Mixing up old and new URLs.

The command replaces the old site URL with the new one and skips the 'guid' column to avoid breaking links.

5fill in blank

hard

Fill all three blanks to create a WP-CLI command that exports the database, imports it, and updates URLs during migration.

Wordpress

wp db export [1].sql && wp db import [2].sql && wp search-replace '[3]' 'http://newsite.com' --skip-columns=guid

Drag options to blanks, or click blank then click option'

Abackup

Chttp://oldsite.com

Dexport

Attempts:

3 left

💡 Hint

Common Mistakes

Using different file names for export and import.

Swapping old and new URLs in search-replace.

This sequence exports the database to 'backup.sql', imports it back, and replaces the old URL with the new one, skipping the 'guid' column.

Practice

1. What is the main purpose of migrating a WordPress site between environments?

easy

A. To move the site safely from one place to another

B. To change the site's theme permanently

C. To delete all plugins and start fresh

D. To increase the site's loading speed automatically

Solution

1. Step 1: Understand migration meaning

   Migration means moving a site from one environment (like local or staging) to another (like live).

2. Step 2: Identify the main goal

   The goal is to move the site safely without losing data or breaking it.

3. Final Answer:

   To move the site safely from one place to another -> Option A

4. Quick Check:

   Migration = safe site move [OK]

Hint: Migration means moving site safely between places [OK]

Common Mistakes:

• Thinking migration changes themes automatically
• Assuming migration deletes plugins
• Believing migration speeds up site by itself

2. Which of the following is the correct way to update URLs after migrating a WordPress site?

easy

A. Change URLs only in the wp-config.php file

B. Manually edit URLs in the database using a search and replace tool

C. Leave URLs as they are; WordPress updates them automatically

D. Delete the .htaccess file to reset URLs

Solution

1. Step 1: Recognize URL update necessity

   After migration, URLs often need updating to match the new domain or path.

2. Step 2: Choose the correct method

   Using a search and replace tool on the database is the proper way to update all URLs safely.

3. Final Answer:

   Manually edit URLs in the database using a search and replace tool -> Option B

4. Quick Check:

   Update URLs with search and replace [OK]

Hint: Use search and replace tool on database URLs [OK]

Common Mistakes:

• Thinking wp-config.php controls URLs
• Assuming WordPress auto-updates URLs always
• Deleting .htaccess breaks site rules

3. After migrating a WordPress site manually, which step ensures the media files are correctly moved?

medium

A. Change the site URL in wp-config.php

B. Only export the database; media files move automatically

C. Reinstall all plugins to restore media files

D. Copy the wp-content/uploads folder to the new environment

Solution

1. Step 1: Identify media file location

   Media files are stored in the wp-content/uploads folder in WordPress.

2. Step 2: Ensure media files move

   Copying this folder to the new environment keeps all media intact.

3. Final Answer:

   Copy the wp-content/uploads folder to the new environment -> Option D

4. Quick Check:

   Media files = wp-content/uploads copy [OK]

Hint: Copy uploads folder to move media files [OK]

Common Mistakes:

• Thinking media files move with database only
• Reinstalling plugins does not restore media
• Changing wp-config.php does not move files

4. You migrated your WordPress site but see broken links and missing images. What is the most likely cause?

medium

A. You forgot to update URLs in the database after migration

B. You copied the uploads folder twice

C. You changed the site URL in the wp-config.php file correctly

D. You used a plugin to migrate the site

Solution

1. Step 1: Analyze symptoms

   Broken links and missing images usually mean URLs still point to the old site.

2. Step 2: Identify cause

   If URLs in the database are not updated, links break after migration.

3. Final Answer:

   You forgot to update URLs in the database after migration -> Option A

4. Quick Check:

   Broken links = URLs not updated [OK]

Hint: Broken links? Check database URLs first [OK]

Common Mistakes:

• Assuming copying uploads twice fixes links
• Thinking changing wp-config.php fixes broken links
• Believing plugins always fix URL issues automatically

5. You want to migrate a WordPress site from a local environment to a live server. Which sequence of steps is best practice?

hard

A. Install WordPress fresh on live, then copy themes and plugins manually

B. Copy wp-content folder only, then change site URL in wp-config.php

C. Export database, copy wp-content folder, update wp-config.php, replace URLs in database

D. Export database and import it on live, no need to copy files

Solution

1. Step 1: Export database and copy files

   Exporting the database and copying the wp-content folder moves content and media.

2. Step 2: Update configuration and URLs

   Update wp-config.php for database access and replace URLs in the database to match live site.

3. Final Answer:

   Export database, copy wp-content folder, update wp-config.php, replace URLs in database -> Option C

4. Quick Check:

   Full migration = DB export + files + config + URL update [OK]

Hint: Export DB, copy files, update config and URLs [OK]

Common Mistakes:

• Copying files without exporting database
• Changing wp-config.php without URL updates
• Installing fresh WordPress loses content