Bahriddin Mo'minov )) Blog

2021-12-21 06:39:48 #php #psr #psr1 Ochish/sharhlash

2021-12-17 10:30:14 #php #psr #psr1 Ochish/sharhlash

2021-10-09 19:00:14 # composer.lock faylida belgilangan paketlarni o’rnatadi,
# agar comopser.lock faylini topa olmasa,
# composer.json fayliga asoslanib paketlar o’rnatadi va
# composer.lock faylini yozadi
composer install

# Hech qanday paket o’rnatmaydi,
# lekin o’rnatish jarayonini simulyatsiya qilaydi.
# * (o’rnatishni to’liq test qiladi)
composer install --dry-run

# Barcha paketlarni yangilaydi
composer update

# Barcha paketlarni va ular bog’liq bo’lgan paketlarni yangilaydi
composer update --with-dependencies

# Faqat bitta paketni yangilaydi
composer update vendor/package

# vendor’ga tegishli barcha paketlarni yangilaydi
composer update vendor/*

# composer.lock fayliga o’zgartirish kiritmasdan
# barcha paketlarni yangilaydi
composer update --lock

# Barcha paketlarni yangilaydi
composer update

# autoload fayllarini qaytadan optimizatsiya qilib yozadi
composer dumpautoload -o

# vendor/package paketini o’rnatadi va
# composer.json’ning require bo’limiga yangi paketni qo’shadi
composer require vendor/package

# vendor/package paketini o’rnatadi va
# composer.json’ning require-dev bo’limiga yangi paketni qo’shadi
composer require vendor/package --dev

# vendor/pkg paketini 1.3.2 versiyasini o’rnatadi
composer require vendor/pkg "1.3.2"

# vendor/pkg paketini 1.3.2 versiyasini yoki
# undan katta versiyasini o’rnatadi
composer require vendor/pkg ">=1.3.2"

# vendor/pkg paketini 1.3.2 versiyasidan kichik versiyasini o’rnatadi
composer require vendor/pkg "<1.3.2"

# vendor/pkg paketini 1.3.0’ga teng yoki katta va
# 1.4.0’dan kichik versiyasini o’rnatadi
composer require vendor/pkg "1.3.*"

# vendor/pkg paketini 1.3.0’ga teng yoki katta va
# 1.4.0’dan kichik versiyasini o’rnatadi
composer require vendor/pkg "~1.3.2"

# vendor/pkg paketini 1.3.0’ga teng yoki katta va
# 2.0.0’dan kichik versiyasini o’rnatadi
composer require vendor/pkg "~1.3"

# vendor/pkg paketini 1.3.2’ga teng yoki katta va
# 2.0.0’dan kichik versiyasini o’rnatadi
composer require vendor/pkg "^1.3.2"

# vendor/pkg paketini 1.3.0’ga teng yoki katta va
# 2.0.0’dan kichik versiyasini o’rnatadi
composer require vendor/pkg "^1.3"

# vendor/pkg paketini 0.3.2’ga teng yoki katta va
# 0.4.0’dan kichik versiyasini o’rnatadi
composer require vendor/pkg "^0.3.2"

# vendor/pkg paketini BRANCH_NAME nomidagi brenchini o’rnatadi
composer require vendor/pkg "dev-BRANCH_NAME"

# vendor/package paketni o’chiradi,
# composer.json faylidan ham o’chiradi
composer remove vendor/package Ochish/sharhlash

2021-05-26 20:19:13 # Get a backup from postgresql
# local
pg_dump --username=postgres --password dbname > dbname.bak

# remote
pg_dump --host=remotehost --port=5432 --username=postgres --password --dbname=DBNAME > dbname.bak

# Restore backup
# with psql
psql --username=username dbname < dbname.bak

psql -U postgres -p 5432 -d DBName -f

# with pg_restore
pg_restore --username=username --dbname=dbname -1 filename.dump

Manba: @bahriddin_blog
#pgsql #postgres #sql #postgresql #get #local #remote #backup #restore #backup Ochish/sharhlash

2021-05-24 21:47:24 # Get a backup from mysql
# local
mysqldump dbname --result-file=E:/backup.sql --user=root --host=localhost --password

# remote
mysqldump dbname --result-file=E:/emote.sql --user=root --host=192.168.11.132 --port=3306 --password


Manba: @bahriddin_blog
#mysql #get #local #remote #backup Ochish/sharhlash

2021-05-24 21:42:53 #MySQL Database get backup

mysql -u dbuser -p
## Enter -> write password -> Enter

ALTER USER 'username'@'localhost' IDENTIFIED BY 'new_pass';
# Enter
FLUSH PRIVILEGES;
# Enter
exit;
# Enter
# Verify password
mysql -u root -p
# Enter and write new password

Manba: @bahriddin_blog
#mysql #password #change Ochish/sharhlash