How to import/export WP database
-
Determine the Lightsail root password
cat bitnami_application_password -
Export the database
mysqldump -u root -p -h localhost bitnami_wordpress > /opt/bitnami/wordpress/backup.sql -
Download the export file and import via local DB tool