php

Debian 11 bullseye drupal local environment

Clone the repository into ~/projects/drupal/projectname

** Dump database from production **

2. Dump database from prod drupal website using drush:

../vendor/drush/drush/drush sql-dump --gzip --result-file=../db_dump_08072023_1102am_latest.sql

3. Copy dump db from local using rsync

rsync --progress username@domainname.com:~/directory/db_dump_08072023_1102am_latest.tar.gz ~/projects/drupal/projectname

* Create mysql user

edit file sources.list

$ sudo nano /etc/apt/sources.list

add

deb http://packages.dotdeb.org wheezy all
deb-src http://packages.dotdeb.org wheezy all
deb http://packages.dotdeb.org wheezy-php56-zts all
deb-src http://packages.dotdeb.org wheezy-php56-zts all

Then run

$ sudo apt-get update
$ sudo apt-get upgrade
$ sudo apt-get install php5

To reset MYSQL root password:

$ sudo dpkg-reconfigure mysql-server-5.5

Grant all privileges to a user

$ GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'%' WITH GRANT OPTION;

Create a php script with a header #!/usr/bin/env drush

my_php_script.php
#!/usr/bin/env drush
<?php 
echo drush_get_option('param');
exit();

Drush command to run the php script from cli

$ drush scr my_php_script.php --param="this is a test"