SELECT table_name AS “Table”,
ROUND(((data_length + index_length) / 1024 / 1024), 2) AS “Size (MB)”
FROM information_schema.TABLES
WHERE table_schema = “wbxpress”
ORDER BY (data_length + index_length) DESC;
mysql
Commands to Host WordPress in LEMP (Ubuntu 20.04)
Necessary commands to host a LEMP stack in Ubuntu 20.04 in a Lionde VPS. These commands are applicable for any other VPS too e.g. Digital Ocean. First thing you need to buy a VPS. Its start with a price of $5 per month where you can host unlimited websites.
Host Multiple Sites with SSL in Ubuntu 20.04
We will show only the commands necessary for hosting website. We will also show how to use https i.e. SSL for the websites. Your website can be of any type. We are showing WordPress installation although the commands are almost same.
Host Multiple Sites with SSL in Ubuntu 18.04
In this tutorial we shall share all the commands necessary to host multiple websites in a VPS server. We used VPS servers from Linode and Digital Ocean. Both are excellent and best value for money.
Host Multiple Sites with SSL in LAMP
How to host multiple websites in a single VPS in LAMP environment. All sites will use SSL certificates (https). All commands are for shown considering Ubuntu linux.
Add Administrator of WordPress through MySQL
If you can not login to your wordpress site using administrator account in conventional methos, then you may create another administrator account using mysql commands.