Export a SQL file from a non-VIP WordPress install

In order to migrate existing database content to VIP, a SQL file must be exported from a current WordPress site.

Database export plugins

Third-party plugin that are designed to export WordPress database content can be installed on the non-VIP site in order to migrate the content. Find a database export plugin that best matches a customer’s criteria by reviewing options on WordPress.org’s Plugins library.

Database exports in the command line

The database of a WordPress site can be exported by running a mysqldump command in a command line interface. This command example demonstrates a mysqldump command formatted to output a database file that is most likely to be suitable for import to a VIP Platform environment:

mysqldump --add-drop-table --hex-blob --no-create-db --quote-names -h dbhost -u user -p dbname --default-character-set=utf8mb4 --result-file=dbname-full.sql

Database exports from phpMyAdmin

It is possible to export a database file from a WordPress site with phpMyAdmin that is suitable for import to a VIP Platform environment. However this option should be taken with great caution.

Exports from phpMyAdmin are highly configurable and some settings may include SQL statements that are not compatible with VIP’s import tooling (e.g., CREATE DATABASE IF NOT EXISTS, USE, ALTER USER, or SET PASSWORD).

To ensure compatibility, validate a SQL database file export from phpMyAdmin with VIP-CLI before importing it to a VIP Platform environment.