To migrate content onto VIP Go, we need two assets:
- The database file as a SQL dump, and
- The media as a compressed archive.
Files to import can be attached to a Zendesk ticket — or files larger than 20 MB can be transferred via sending us a web-accessible link to the files (eg
https://www.mysite.com/uploads.tar.gz). You may also use Amazon S3, Dropbox, Box, WeTransfer, or another similarly secure service. Please also be sure to include the domain name of the VIP Go environment the import is for.
To make your database available to VIP, you must first export a backup copy from your local or current, non-VIP production instance. Two such methods are using
mysqldump from the command line, or via a third-party WordPress plugin such as WP Migrate DB Pro. Here is a sample mysqldump command:
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
Other methods for exporting your database, including using phpMyAdmin, are detailed on WordPress.org.
Database formatting checklist
Once you have exported your database, please confirm:
- Will domains need to be replaced on import? For instance, changing a domain used in a local environment (example.test) or running production instance (example.com) to the pre-launch VIP convenience domain (example.go-vip.net)?
- Verify the tables prefixed with
- Ensure that a
DROP TABLE IF EXISTSstatement is included before each
- Remove all
- Exclude any unused tables, such as custom tables from plugins no longer in use.
You can use the VIP CLI command
vip import validate-sql to verify the format of your SQL file.
In addition, for multisite
Are you importing into a Multisite Network? If so:
- Your database needs to also be from a multisite.
- If importing subsite tables, ensure the table prefixes match the intended destination site ID (e.g. tables prefixed
wp_3_will be imported to subsite 3).
- If you are importing an entire multisite network, does your export have the
- If you are importing only individual subsites, are those the only tables included in your export?
Submitting the database
Please open a new Zendesk ticket for each import. Your database can be attached to the Zendesk ticket; or, if it’s larger than 20 MB, it can be transferred via sending us a web-accessible link to the files (e.g.
https://www.example.com/uploads.tar.gz). You may also use Amazon S3, Dropbox, Box, WeTransfer, or another similar service.
When you submit your database, please list domains included in the database and what you’d like them replaced with, if needed. If necessary, we will perform a search-replace to change these values to match your VIP environment. This is the only modification VIP expects to perform on your database; it will otherwise be imported as-is. All tables provided will be replaced.
If your SQL file includes the
wp_users table, this will replace your VIP environment’s users table, meaning your username and login in our environment may change after the import.
Once we confirm that your database has been imported into your VIP environment, you’ll want to perform some quality assurance testing to ensure it matches your expectations. Here are some ways to test your site.