Assign Content of Deleted Anonymous User to a Real User using mysql command as there is no option of doing this from wordpress dashboard. 1. Create a user from admin panel and note down the userid. Suppose it is 1623. 2. Then run the following SQL query.
mysql
Check all Table Size of a MySQL Database using Command
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;
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.