Install the WP-DBManager plugin
NOTE: The Approach A sections referred to below do not apply to Bitnami native installers. Users of Bitnami native installers should refer only to the Approach B sections.
Approach A: Bitnami installations using system packages
If you install WP-DBManager you must add the htaccess example provided by the plugin into the wordpress-htaccess.conf file and you must create an empty .htaccess file in the backup-db directory to pass the plugin checks. To do it, run the commands below:
$ echo '<Directory "installdir/wordpress/wp-content/backup-db">' >> installdir/apache2/conf/vhosts/htaccess/wordpress-htaccess.conf
$ cat installdir/wordpress/wp-content/plugins/wp-dbmanager/htaccess.txt >> installdir/apache2/conf/vhosts/htaccess/wordpress-htaccess.conf
$ echo "" >> installdir/apache2/conf/vhosts/htaccess/wordpress-htaccess.conf
$ echo '</Directory>' >> installdir/apache2/conf/vhosts/htaccess/wordpress-htaccess.conf
$ touch installdir/apps/wordpress/htdocs/wp-content/backup-db/.htaccess
Finally, once you activate the plugin in your WordPress dashboard, you must ensure that in the plugin DB Option the mysql and mysqldump paths are correct. For example, use the paths installdir/mariadb/bin/mysql and installdir/mariadb/bin/mysqldump.
Approach B: Self-contained Bitnami installations
If you install WP-DBManager you will need to create the installdir/apps/wordpress/htdocs/wp-content/backup-db directory. To do it, you must connect to your machine through SSH, and run this command:
$ mkdir installdir/apps/wordpress/htdocs/wp-content/backup-db
Once you have done it, you must add the htaccess example provided by the plugin into the htaccess.conf file and you must create an empty .htaccess file in the backup-db directory to pass the plugin checks. To do it, run the commands below:
$ echo '<Directory "installdir/apps/wordpress/htdocs/wp-content/backup-db">' >> installdir/apps/wordpress/conf/htaccess.conf
$ cat installdir/apps/wordpress/htdocs/wp-content/plugins/wp-dbmanager/htaccess.txt >> installdir/apps/wordpress/conf/htaccess.conf
$ echo "" >> installdir/apps/wordpress/conf/htaccess.conf
$ echo '</Directory>' >> installdir/apps/wordpress/conf/htaccess.conf
$ touch installdir/apps/wordpress/htdocs/wp-content/backup-db/.htaccess
Finally, once you activate the plugin in your WordPress dashboard, you must ensure that in the plugin DB Option the mysql and mysqldump paths are correct. For example, use the paths installdir/mysql/bin/mysql and installdir/mysql/bin/mysqldump.