Set environment variable for php
sudo -i
nano /etc/environment
press End button and add :/opt/lampp/bin
ctrl + O
enter
ctrl + X
-------------------------------------------------------------------------------------------------
Magento 2 Commands
sudo chmod -R 777 *
rm -rf var/cache/ var/page_cache/ var/view_preprocessed/ pub/static/frontend/ pub/static/adminhtml/
php -dmemory_limit=8G bin/magento cache:clean
php -dmemory_limit=8G bin/magento cache:flush
php -dmemory_limit=8G bin/magento catalog:images:resize
php -dmemory_limit=8G bin/magento setup:upgrade
php -dmemory_limit=8G bin/magento setup:di:compile
php -dmemory_limit=8G bin/magento indexer:reset
php -dmemory_limit=8G bin/magento indexer:reindex
php -dmemory_limit=8G bin/magento setup:static-content:deploy -f
Magento 2 plesk server command
/opt/plesk/php/7.0/bin/php bin/magento c:c
-------------------------------------------------------------------------------------------------
Disable all custom and Third Party Module in single Command
php bin/magento module:status | grep -v Magento | grep -v List | grep -v None | grep -v -e '^$'| xargs php bin/magento module:disable
-------------------------------------------------------------------------------------------------
Update the system
sudo apt-get update
sudo apt-get upgrade
sudo apt-get dist-upgrade
https://askubuntu.com/questions/462449/update-the-system-from-terminal
-------------------------------------------------------------------------------------------------
Create User by command in magento 2
php bin/magento admin:user:create --admin-user='admin' --admin-password='admin123' --admin-email='info@domain.com' --admin-firstname='Jon' --admin-lastname='Doe'
-------------------------------------------------------------------------------------------------
Import and Export Command for server
mysql -h db -P 3306 -u root -p nestlewaterspk < nestlewaterspk17012019.sql
mysqldump -h db -P 3306 -u root -p nestlewaterspk > nestlewaterspk17012019.sql
mysqldump -h localhost -u root -p tavolashop > tavolashop23032020.sql
Or
/opt/lampp/bin/mysql -u root -p texasoutdoorpatiocenter < texas_latest.sql
/opt/lampp/bin/mysqldump -u root -p texasoutdoorpatiocenter > texas_latest.sql
-------------------------------------------------------------------------------------------------
To go root folder Command
sudo su -
Or
Sudo -i
-------------------------------------------------------------------------------------------------
Zip Command
Creat Zip
zip -r 2232018.zip *
exclude the .git folder in zip
zip -r tavolashop03032019.zip * -x media/\*
Tar Command
tar cvzf name.tar.gz *
exclude the .git folder in tar
tar cvzf tavolashop03032019.tar.gz* --exclude='media'
-------------------------------------------------------------------------------------------------
Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes
mysql -u root -p
set global net_buffer_length=1000000000;
set global max_allowed_packet=1000000000;
-------------------------------------------------------------------------------------------------
SCP examples
Copy file from a remote host to local host SCP example:
-> scp username@from_host:file.txt /local/directory/
Copy file from local host to a remote host SCP example:
-> scp file.txt username@to_host:/remote/directory/
Copy directory from a remote host to local host SCP example:
-> scp -r username@from_host:/remote/directory/ /local/directory/
Copy directory from local host to a remote hos SCP example:
-> scp -r /local/directory/ username@to_host:/remote/directory/
Copy file from remote host to remote host SCP example:
-> scp -r username@from_host:/remote/directory/ username@to_host:/remote/directory/
scp provides a number of options that control every aspect of its behavior. The most widely used options are:
-P Specifies the remote host ssh port.
-p Preserves files modification and access times.
-q Use this option if you want to suppress the progress meter and non-error messages.
-C This option will force scp to compresses the data as it is sent to the destination machine.
-r This option will tell scp to recursively copy directories.
-------------------------------------------------------------------------------------------------
php /opt/sublime_text/sublime_text
phtml /opt/sublime_text/sublime_text
css /opt/sublime_text/sublime_text
js /opt/sublime_text/sublime_text
less /opt/sublime_text/sublime_text
. /opt/sublime_text/sublime_text
log /opt/sublime_text/sublime_text
html /opt/sublime_text/sublime_text
xml /opt/sublime_text/sublime_text
.ini /opt/sublime_text/sublime_text
sample /opt/sublime_text/sublime_text
ini /opt/sublime_text/sublime_text
list /opt/sublime_text/sublime_text
/ /opt/sublime_text/sublime_text
ip /opt/sublime_text/sublime_text
txt /opt/sublime_text/sublime_text
jmx /opt/sublime_text/sublime_text
Remove right click magento 2
app/design/frontend/homesmith/theme01/Magento_Theme/layout/default.xml
Additional hours add form:
https://docs.google.com/forms/d/e/1FAIpQLScwzQ4_Iro_xflQ3q7J0tq95JTWbO3hd2LqNsYAVZdTd_DZSA/viewform?vc=0&c=0&w=1
weekly report:
https://docs.google.com/spreadsheets/d/1qQMGnGdOH1fcTPpz73toOkmmAlHXV8IxBjMSTmJwboU/edit?ts=5e773b2c#gid=749439442
april: https://docs.google.com/spreadsheets/d/1fyvr8OzFuqOqsq0ThUt3iQgSYciq4jXKb3rH7aLsffk/edit?pli=1#gid=1715145362
may:https://docs.google.com/spreadsheets/d/1NePi0SLXyCzcED8hwBBw7Jv6BfVwjo0Hx3gpYxwUPzI/edit#gid=1388602065
june: https://docs.google.com/spreadsheets/d/1UfvboT3i4PlqGD6xYeMO9D9Y4XrBpr3iZlhVn3L5sMU/edit#gid=117058586
July: https://docs.google.com/spreadsheets/d/1v2al0D7Q2ZcOumGj4JqJn5spd3pv2xVZrDaULovjW-k/edit#gid=260077347
August: https://docs.google.com/spreadsheets/d/1aRZqwGVQlztZ8Cu7bNng6HrzXKtJgtRuhtDQm4MC8f4/edit#gid=260077347
sept: https://docs.google.com/spreadsheets/d/1AIhftS8wy4WJm9nj8H9gomMVMFAW1CKqt-KK-mt7Rxs/edit?usp=drive_web&ouid=106498797537587860631
Oct: https://docs.google.com/spreadsheets/d/1SbrtRLO2bOg7r_llWqvwwGV-NsNCwyGChC0KajE0_VI/edit#gid=798936410
Nov: https://docs.google.com/spreadsheets/d/1HYl1SssIwXFcu7SQtXsoBftJ6GRT7J7jElx-jzNaigA/edit#gid=139608169
ajmal androdid ios hours:
https://docs.google.com/spreadsheets/d/1AEudHpUgq7qYDtbrlh4pez-Wb1GT5T4RBORySPTjSs8/edit#gid=0
Redsea estimation:https://docs.google.com/document/d/14LGRv_u6cQxGGUAXnYk1XUuRfBA4Ws-E_et6WyNatvw/edit
Resea: https://docs.google.com/spreadsheets/d/1iKfT3HzcBRZGQYyT19VKcv5fAjvUJUuf/edit#gid=2053144343
Jira filter:https://ktpl-nestlewaters.atlassian.net/browse/NWUAE-364?jql=issuetype%20in%20(Story%2C%20Task)%20AND%20project%20%3D%20NWUAE%20AND%20Sprint%20%3D%203%20ORDER%20BY%20priority%20DESC
https://docs.google.com/spreadsheets/d/1fwGSSFE0Gp13FLlJwFuVIe2lcRaoxvRc/edit#gid=1159840007
Nestle accesses:
https://jenkins-nml.westeurope.cloudapp.azure.com
ptrivedi
InitialParth!@#
Nestle MObile api sheet:
https://docs.google.com/spreadsheets/d/1xy9ZwLP4yiBn52yGXDKc7dGOOSZQPJzMNJMdNxC13MA/edit?ts=5ee88cf4#gid=0
https://docs.google.com/spreadsheets/d/1aKoLe7nskNLJeyTysMe4TRvedaYWlUZMvjqVDcAcA7M/edit#gid=2125144427
https://drive.google.com/file/d/1YFi8eFrEiwmNT4tz3QLEBceQ3TSz2TOb/view?usp=sharing
https://ktpl-nestlewaters-mobile.atlassian.net/secure/RapidBoard.jspa?rapidView=4&projectKey=NWM
New HTTP auth:
User: nwme
Pass: *jaIAtv7QC45c|^kM^=B]{O=gbEm%K
platformsh pass:IIndi@1947
IIndi@1947
User: nwme
Pass: *jaIAtv7QC45c|^kM^=B]{O=gbEm%K
Geetansh Jira nestle UAE:
Admin@123
mysqldump -u username -p your_db_name | gzip -9 > your_db_name.sql.gz
php bin/magento config:set --lock-env --scope default --scope-code 0 web/secure/base_url https://int-nwuiyna-m3hcbmy666vug.eu-4.platformsh.site/
php bin/magento config:set --lock-env --scope default --scope-code 0 web/unsecure/base_url https://int-nwuiyna-m3hcbmy666vug.eu-4.platformsh.site/
php bin/magento config:set --lock-env --scope default --scope-code 0 admin/url/custom https://int-nwuiyna-m3hcbmy666vug.eu-4.platformsh.site/
php bin/magento config:set --lock-env --scope default --scope-code 0 admin/url/use_custom 0
platform --project=m3hcbmy666vug --environment=master sql < nwaem2migration28102020_new.sql
mysqldump -h db -P 3306 -u nwaem2migration -p nwaem2migration > nwaem2migration21102020drill.sql
mysqldump -h db -P 3306 -u nwaem2migration -p nwaem2migration | gzip -9 > nwaem2migration28102020.sql.gz
AlEq0sivpTadvrMR
sed 's/DEFINER=`t3v2cwstage`@`%`/DEFINER=CURRENT_USER/g' php7magstg_21-02-12.sql > php7magstg_21-02-12_new.sql
/*!50017 DEFINER=`nwaem2migration`@`%`*/
/*!50017 DEFINER=CURRENT_USER*/
gzip -d nwaem2migration28102020.sql.gz
UPDATE core_config_data SET value = 'http://localhost/magento23' WHERE path = 'web/secure/base_url';
UPDATE core_config_data SET value = 'http://localhost/magento23' WHERE path = 'web/unsecure/base_url';
https://control-prod.buyonline.nestlewaters.ae/adminer.php
172.17.138.102
buyonline
Chaeja4z
ecommerce@ae.nestle-waters.com
NestleWaters@2020
twilio.com/
LEB cybersuoce test:
Organization ID: blom_sohat
Username: blom_sohat
Password: blom5R42sbank
LEB SMS:
ecommerce@lb.nestle-waters.com
NestleWatersLeb
Indiaa@19479988
scp zspielem1121de@spielematerial.de:/var/www/vhosts/spielematerial.de/m2stage/app/etc/env.php /var/www/html/spielematerial/app/etc
git remote add origin git@git.web-vision.io:mag2/spielematerial.de.git
ssh zspielem1121de@spielematerial.de
scp zcwmobil1140stg@stage.cw-mobile.de:/var/www/vhosts/stage.cw-mobile.de/mysqldump/php7magstg_21-02-12.sql /var/www/html/cwmobile
sudo modprobe -r rtl8723be
sudo modprobe -v rtl8723be ant_sel=1
mysqldump -u spielematerialM2live -p m24schmuckstg | gzip -9 > m24schmuckstg20042021.sql.gz
mysql -u m2demoewprod -p Th0tc7!1 m2demoewprod < M2_DEMO_CLEANED.sql
mysqldump -u spielematerialM2live -p spielematerialM2live > spielematerialM2live-compromized-maybe-09092022.sql
mysqldump -h 185.88.215.54 -u db-user-4 -p db-4 | gzip -9 > pk_live_15092022.sql.gz
mysqldump -h localhost -u m2stagechemical -p m2stagechemical | gzip -9 > stagedb-18112022.sql.gz
mysqldump -h 185.88.215.54 -u db-user-4 -p db-4 | gzip -9 > live28-03.sql.gz
unlink current && ln -s releases/20 current
ln -s sites/update/current update
ln -s sites/production/current www && ln -s sites/stage/current stage && ln -s sites/relaunch/current relaunch
mysqldump -h localhost -u m2demoewprod -p m2demoewprod > live22-08.sql
mysqldump -h localhost -u db-user-5 -p db-5 > db-ppc-17-10-2023.sql
/opt/homebrew/etc/httpd
brew unlink php@7.4
brew unlink php@7.4
ln -s sites/stage/current httpdocs
ln -s sites/stage/releases/19 httpdocs
mysqldump -h localhost -u prelive.mz-at -p prelive.mz-at | gzip -9 > 15042024_before_orders.sql.gz
~Ucvu8507
mysqldump -h localhost -u db-user-1 -p db-1 | gzip -9 > bt-stage-24072024.sql.gz
F1FFWVBM8U9nZR4yd7aX
16:00:54 c-2352 ~ $ ls -l $(which php)
lrwxrwxrwx 1 root root 21 Jul 5 2022 /usr/bin/php -> /etc/alternatives/php
16:01:00 c-2352 ~ $ ls -l /etc/alternatives/php
lrwxrwxrwx 1 root root 15 Dec 2 16:00 /etc/alternatives/php -> /usr/bin/php8.2
16:01:03 c-2352 ~ $ ls /usr/bin/php*
/usr/bin/php /usr/bin/php8.0 /usr/bin/phpdbg7.2 /usr/bin/phpdbg8.1
/usr/bin/php7.2 /usr/bin/php8.1 /usr/bin/phpdbg7.3 /usr/bin/phpdbg8.2
/usr/bin/php7.3 /usr/bin/php8.2 /usr/bin/phpdbg7.4 /usr/bin/php.default
/usr/bin/php7.4 /usr/bin/phpdbg /usr/bin/phpdbg8.0
watch -n 1 'mysql -u root -pyour_password -e "SHOW PROCESSLIST;"'