Install the WP-DBManager plugin

Before running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and MacOS) or by clicking the shortcut in the Start Menu under “Start -> Bitnami APPNAME Stack -> Application console” (Windows). On OS X VMs, the installation directory is /opt/bitnami and OS X VM users can click the “Open Terminal” button to run commands. Learn more about the Bitnami stack environment and about OS X VMs.

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.

Last modification April 8, 2020