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...
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...
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...
To find Plesk version, login to the server and run
plesk version
plesk version
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
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...
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...
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...