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.