For Programming

SERVERGA PHP O"RNATISH

sudo apt update
sudo apt upgrade

sudo apt install software-properties-common
sudo add-apt-repository ppa:ondrej/php
sudo apt update

sudo apt install php8.1-fpm php8.1-cli php8.1-curl php8.1-pgsql php8.1-gd php8.1-mbstring php8.1-mysql php8.1-xml php8.1-zip php8.1-pdo

php -v php versiyasini ko'rish
php -m php modullarini ko'rish

41 viewsedited 05:48

For Programming

SERVERGA MySQL O"RNATISH

sudo apt update
sudo apt install mysql-server

MySQL ni SOZLASH

sudo mysql

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by 'mynewpassword';
sudo mysql_secure_installation

51 viewsedited 06:22

For Programming

mysqldump -u root -p'mypassword' mydb > mypath/dump.sql

34 views17:50

For Programming

sudo chown www-data ./runtime -R
sudo chown www-data ./web/assets -R

33 views20:01

For Programming

https://getgrav.org/blog/macos-ventura-apache-multiple-php-versions

Grav CMS

macOS 15.0 Sequoia Apache Setup: Multiple PHP Versions

Grav is a Modern, Crazy Fast, Ridiculously Easy and Amazingly Powerful Flat-File CMS.

24 views04:42

For Programming

sudo service postgresql restart

22 views05:19

For Programming

Forwarded from Sharof Xudayberdiyev

https://stepik.org/course/63054/promo

Stepik: online education

Интерактивный тренажер по SQL

В курсе большинство шагов — это практические задания на создание SQL-запросов. Каждый шаг включает минимальные теоретические аспекты по базам данных или языку SQL, примеры похожих запросов и пояснение к реализации.

17 views04:56

For Programming

Forwarded from Qosimjon

# 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