Rapturezone

WordPress MultiSite Bitnami Essentials

by

WordPress MultiSite Bitnami Essentials

SOP: Adding New TLS Website to WordPress MultiSite Bitnami Instance

Adding New TLS Website to WordPress MultiSite Bitnami Instance

Add New Website to WordPress MultiSite

Stop Websites

sudo /opt/bitnami/ctlscript.sh stop

Backup Websites

Restore Websites

TLS Certificates

Adding New TLS Website to WordPress MultiSite Bitnami Instance

Multiple Domains Multiple Certificates Let’s Encrypt Certificates on WordPress Multisite AWS Lightsail using bncert-tool

Fix Error establishing a database connection after issuing a new certificate

Let’s Encrypt Certificate on WordPress AWS Lightsail

WordPress Multisite on Amazon Lightsail AWS

MySQL Command Line

Connect Database

mysql -u root -p
Enter password: **********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6761
Server version: 21.0.18 MySQL Community Server - GPL
Copyright (c) 2000, 2021, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

List Databases

SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| bitnami_wordpress |
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
5 rows in set (0.01 sec)
mysql>

Select Database

use bitnami_wordpress;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed

List Tables

show tables;
+-------------------------------------+
| Tables_in_bitnami_wordpress |
+-------------------------------------+
| wp_2_commentmeta |
| wp_2_comments |
| wp_2_links |
| wp_2_options |
| wp_2_postmeta |
| wp_2_posts |
| wp_2_prli_clicks |
| wp_2_prli_link_metas |
| wp_2_prli_links |
| wp_2_term_relationships |
| wp_2_term_taxonomy |
| wp_2_termmeta |
| wp_2_terms |
| wp_blogmeta |
| wp_blogs |
| wp_commentmeta |
| wp_comments |
| wp_links |
| wp_options |
| wp_postmeta |
| wp_posts |
| wp_prli_clicks |
| wp_prli_link_metas |
| wp_prli_links |
| wp_registration_log |
| wp_signups |
| wp_site |
| wp_sitemeta |
| wp_term_relationships |
| wp_term_taxonomy |
| wp_termmeta |
| wp_terms |
| wp_usermeta |
| wp_users |
+-------------------------------------+

Dump/Backup Database

mysqldump -u root -p bitnami_wordpress > backup.sql

Dump/Backup Database Table

mysqldump -u root -p bitnami_wordpress wp_2_posts > backup_database_table.sql

PHPMyAdmin

is available over port 80/phpmyadmin. However if you try to access it over the internet. The following error comes up.

For security reasons, this URL is only accessible using localhost (127.0.0.1) as the hostname.
sudo nano ~/.ssh/config

Add the following into the config file

Host WordPressMultiSIte
  User bitnami
  AddressFamily inet
  IdentityFile ~/.ssh/id_rsa
  HostName rapturezone.com
  LocalForward 8888 127.0.0.1:80

Open a browser and access it via http://127.0.0.1:8888/phpmyadmin.
The username is “root” and the password is the same as the WordPress User account.

  • https://docs.bitnami.com/bch/apps/wordpress-multisite/administration/backup-restore/

Google+