Cover Image by MilesAndryPrower on DeviantArt

☑ Optimize a MySQL database

If you have deleted a large part of your table or updated many variable length rows, you should consider running the optimize command. If you want to quickly generate the optimize commands for every table in you database, executing the...

what is cpanel 540x304 - ⚠️ cPanel error: mysql database size 0MB

⚠️ cPanel error: mysql database size 0MB

You may see the mysql database size as zero in cPanel >> ‘Mysql Databases’ option, though the databases contains tables and data. In order to include the size of the databases while displaying disk usage in cPanel/WHM, perform...

mongodb - SQL to Mongo correspondence table

SQL to Mongo correspondence table

This list is the PHP version »SQL to Mongo correspondence table (there is a more general version in the official MongoDB manual). SQL queryMongo query statementCREATE TABLE USERS (a Number, b Number)Implicit creation...

plesk 540x304 - Find Plesk Version

Find Plesk Version

To find Plesk version, login to the server and run

plesk version

plesk version

phpmyadmin limit 540x304 - Increase PHPMyAdmin upload limit in cPanel

Increase PHPMyAdmin upload limit in cPanel

To increase PHPMyAdmin upload limit in cPanel edit the following file:

nano /usr/local/cpanel/3rdparty/etc/php.ini

and change the following values:

upload_max_filesize = 150M
post_max_size = 150M

apache 540x304 - How to Auto-Renew SSL on Password Protected 🔒 site Apache ✔️

How to Auto-Renew SSL on Password Protected 🔒 site Apache ✔️

On a website that is password protected using Apache basic authentication to auto-renew SSL we need to make the .well-known folder to be accessible without password. Password protected Apache website: <Directory "/var/www/html/"> AuthType...

linux - Create a .zip or .tar.gz archive in Ubuntu Linux (command line)

Create a .zip or .tar.gz archive in Ubuntu Linux (command line)

With Gnome, this is as easy as opening a file browser > select file(s) > right click > Compress… Here are the simple cases for the command line.  For many more advanced options, check the man pages for zip and tar. zip -r...

linux - Linux / Unix rcp command

Linux / Unix rcp command

Copies files from one computer to another computer. Syntax rcp [-p] [-r] filename … directory -pAttempt to give each copy the same modification times, access times, modes, and ACLs if applicable as the original file.-rCopy each subtree rooted...