SQL

SQL - Install, setup, tuorials, tips and hacks.

FIX HUGE SQL tables: wp_actionscheduler_actions & wp_actionscheduler_logs [WooCommerce Tips]

by

WooCommerce has become a widely used module by more and more online stores. SEO, product management, inventory, clean and intuitive code, simple administration interface and thousands of plugins developed for Woo, are just some of the arguments for which it is worth a chance when you think of developing an online store. Like any CMS, no Read More

How to move a blog or a WordPress website from HTTP to HTTPS (NGINX)

by

After seeing "How to install SSL (HTTPS Connection) certificate for a website hosted on an NGINX server without cPanel or VestaCP" in the article here, let's see now what we need to do to make the website or blog valid HTTPS. For a WordPress-based website or blog, it's not enough Read More

[Fix phpMyAdmin] The configuration file now needs a secret passphrase (blowfish_secret)

by

Whether phpMyAdmin is installed on an Ubuntu server, CentOS or etc. Fedora distribution, the message “The configuration file now needs a secret passphrase (blowfish_secret) ”in red at the bottom of the index, give headaches. Especially when configured correctly in "/etc/phpMyAdmin/config.inc.php". Of course, the path may vary from one configuration to another, but on CentOS… Read More