Database Management

Accessing the Database

Database access is available through WP-CLI. See commands.

Importing a database to a WooCart store

You can import an SQL or gzip database by using WebDav and WP-CLI. The database tables need to have a wp_ prefix.

• Upload the database (SQL or gzip) to wp-content folder by using File Transfer. 
• Go to WP-CLI and run wp db import "wp-content/your sql filename.sql"  or zcat "wp-content/your sql filename.sql.gz" | db import -.
• Click Restart PHP Workers so that caches and transients are reloaded.
• Delete the database from the file system.