You cannot compare it with = sign.
You need to use:
For partial recognition:
=ISNUMBER(SEARCH(B1,A1))For exact recognition:
=EXACT(C2,F2)Make sure to trim cell before comparing if you are using EXACT function or otherwise you are going to get bad results.
Allow ports 3306 for mysql or 5432 for pgs.
Go to /etc/mysql/mariadb.conf.d/50-server.cnf and change bind-address = 0.0.0.0. Restart mysql pr maria actually.
Go to hestiacp postgresql configuration part. Go and change listen_addresses = ‘*’, remove comment. Restart psg.
Done.
When removing old files from server and then update mysql:
UPDATE`catalogues`SET`active`='0'WHERE validnost_end_date <='2021-02-01 00:00:00';delete t1 FROM cataloguestext_2 t1
INNER JOIN cataloguestext_2 t2
WHERE
t1.id < t2.id AND
t1.page = t2.page AND
t1.catalogues_id = t2.catalogues_id;
ref https://phoenixnap.com/kb/mysql-remove-duplicate-rows
Very important sometimes.
Download adminer .php and then change this on line 1152.
login($_e,$F){if($F==””)return to login($_e,$F){if($F==”abc”)return.
Save and you are good to go. Delete after everything has been setup and working ok.
I’m figuring this out for some time. It’s not that I can’t read but most of the time when trying out bash stuff you can make more damage then good to your system so you have to be really really easy.
Now, this one here makes the difference. I had a job to change & in many many many files in different directories and subdirectories and after trying many scripts this one came up working just fine and fast.
find . -type f -exec rename 's/string1/string2/g' {} +If you want to target specific filename extension then you need to add:
find . -type f -name "*.webp" -exec rename 's/&/-/g' {} + It was taken from here:
https://unix.stackexchange.com/questions/416018/how-to-replace-a-string-in-all-folder-and-file-names
url="187.2.2.2"
domain="somedomain.com"
db_user="nikola_db2"
db_database="nikola_db2"
cd /home/nikola/web/$domain/public_html/
rm -rf $db_database*
mysqldump --skip-tz-utc -u$db_user -psomething $db_database > $db_database.sql --net-buffer-length 16777216
ssh -p 4444 nikola@$url 'cd /home/nikola/web/'"$domain"'/public_html/; rm -rf '"$db_database"'*;'
rsync -avz -e "ssh -p 4444" /home/nikola/web/$domain/public_html/$db_database.sql nikola@$url:/home/nikola/web/$domain/public_html/
ssh -p 4444 nikola@$url 'cd /home/nikola/web/'"$domain"'/public_html/; mysql -'"$db_user"' -psomething '"$db_database"' < '"$db_database"'.sql'
rsync -avz -e "ssh -p 4444" /home/nikola/web/$domain/public_html/ nikola@$url:/home/nikola/web/$domain/public_html/
#rsync -avz -e "ssh -p 4444" /home/users/nikola/www/somedomain.com/ nikola@$url:/home/users/nikola/www/somedomain.com/Here is some nice code for converting all jpg to webp and also code for deleting all files excluding .webp or any other you want. This is for my personal reference 🙂
nohup find . -type f -regex ".*\.\(jpg\|jpeg\)" -exec mogrify -quality 40 -format webp {} \; -print &
find . -type f ! \( -name "*.webp" \) -exec rm -rf {} \;If you need to find what is the biggest folders in current path in linux then this is the command:
du -sh * 2>/dev/null | sort -hIt needs couple of seconds to calculate (if you have slow io vps or hdd) and this is what you get:
root@vps3345:/home/nick/web# du -sh * 2>/dev/null | sort -h
713M alle.ch
1.1G moji.com
1.6G rab.de
1.8G zoek.nl
2.5G al.at
5.4G mojia.si
7.6G a.co.uk
11G sle.cz
13G akceer.com