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;
Blog
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.
Add Login/ Logout Link at Footer of WordPress site
Add Login / Logout Link at the Footer of your WordPress powered Website. Here in this example we used GeneratePress theme. Edit the footer.php file For GeneratePress theme the path is /wp-content/themes/generatepress/inc/structure/footer.php)
How to Display All Categories in a Page or Post
To display all categories in a single post or page, add the following code into functions.php. Usage: Now create a page and the add the following shortcode: [categories].
Add Widgets in Front Page of Genesis Theme
We have earlier shared “How to Add Widgets to Homepage of Genesis theme”. Now we are sharing a similar guide, “how to add widgets in frontpage of any genesis theme” so that it become a magazine theme.