Install the WP-DBManager plugin

If you install WP-DBManager you will need to create the /opt/bitnami/apps/wordpress/htdocs/wp-content/backup-db directory. To do it, you must connect to your machine through SSH, and run this command:

$ mkdir /opt/bitnami/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 "/opt/bitnami/apps/wordpress/htdocs/wp-content/backup-db">' >> /opt/bitnami/apps/wordpress/conf/htaccess.conf
$ cat /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/wp-dbmanager/htaccess.txt >> /opt/bitnami/apps/wordpress/conf/htaccess.conf
$ echo "" >> /opt/bitnami/apps/wordpress/conf/htaccess.conf
$ echo '</Directory>' >> /opt/bitnami/apps/wordpress/conf/htaccess.conf
$ touch /opt/bitnami/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 /opt/bitnami/mysql/bin/mysql and /opt/bitnami/mysql/bin/mysqldump.

Last modification April 8, 2020