sudo apt install ncdu
ncdu -x /var/
ncdu /etc/ ncdu /tmp/ ncdu /nfs ncdu $HOME
mysql – ERROR: The partition with /var/lib/mysql is too full!
Error:
ERROR: The partition with /var/lib/mysql is too full!
Try:
sudo apt clean
then
sudo service mysql start
That’s all folks. 😉
Let’s Encrypt: Renew Wildcard Certificate With Certbot
certbot certonly --manual --manual-public-ip-logging-ok --preferred-challenges dns-01 --server https://acme-v02.api.letsencrypt.org/directory -d *.yourdomain.com
Linux – see who has sudo / root access
cat /etc/group | grep sudo
Duplicating a MySQL table, indices, and data
To copy with indexes and triggers do these 2 queries:
CREATE TABLE newtable LIKE oldtable; INSERT INTO newtable SELECT * FROM oldtable;
To copy just structure and data use this one:
CREATE TABLE tbl_new AS SELECT * FROM tbl_old;
Yii2 Gii – Table Update
ALTER TABLE `tablename` ADD `lock` int(5) NOT NULL, ADD `created_at` date DEFAULT NULL, ADD `created_by` int(11) NOT NULL DEFAULT 0, ADD `deleted_by` int(11) NOT NULL DEFAULT 0, ADD `deleted_at` date DEFAULT NULL, ADD `updated_at` date DEFAULT NULL, ADD `updated_by` int(11) NOT NULL DEFAULT 0 AFTER branch_status;
Magento Set the File permission
Magento Set the File permission (you need to be root/ sudo)
sudo find var generated vendor pub/static pub/media app/etc -type f -exec chmod g+w {} \; && sudo find var vendor pub/static pub/media app/etc -type d -exec chmod g+ws {} \; && sudo chown -R www-data:www-data . && sudo chmod u+x bin/magento
With the path:
cd /var/www/html/magento2 && find var generated vendor pub/static pub/media app/etc -type f -exec chmod u+w {} + && find var generated vendor pub/static pub/media app/etc -type d -exec chmod u+w {} + && chmod u+x bin/magento
Letsencrypt Force Renew
certbot renew --force-renewal -i apache -d example.com -d www.example.com
Linux and Unix Copy files
To copy a directory with all subdirectories and files, use the cp command. Below is an example command of how you would use the cp command to copy files. Additional information about this command and other examples are available through the above cp link.
cp -r /home/hope/files/* /home/hope/backup
In the example above, the cp command would copy all files, directories, and subdirectories in the /home/hope/files directory to the /home/hope/backup directory.
or
Copy a folder called /tmp/conf to /tmp/backup:
cp -avr /tmp/conf/ /tmp/backup
-a : Preserve the specified attributes such as directory an file mode, ownership, timestamps, if possible additional attributes: context, links, xattr, all.
-v : Explain what is being done.
-r : Copy directories recursively. Example
Cannot access field from join query in search model (Yii2)
echo < pre >; var_dump($query->createCommand()->sql); echo < /pre >;