Tag: MySQL

30 April 2020

Upgrading to PHP 7.3.18 (cli) from 7.0

This will download and install updates for Debian and upgrade PHP from version 7.0 to 7.3 sudo apt update sudo apt upgrade -y sudo apt install ca-certificates apt-transport-https echo “deb https://packages.sury.org/php/ $(lsb_release -sc) main” | sudo tee /etc/apt/sources.list.d/php7.3.list wget -q https://packages.sury.org/php/apt.gpg -O- | sudo apt-key […]

26 May 2020

PHP – Apache – MySQL

To check the status of these services via SSH Apache2 sudo service apache2 status Other commands are STOP / START & RESTART MySQL sudo service mysql status Other commands are STOP / START & RESTART PHP If multiple versions of PHP are running, you can stop […]

26 May 2020

Upgrading to PHP 7.4.6 (cli) from 7.3.18

Using the site’s Health page under tools, make note of the Versions of PHP on the info tab. Using SSH Using “php -v” allows you to check the current version For general updates use: sudo apt update sudo apt upgrade -y PHP Upgrade: php -v […]

17 October 2020

General Updates including PHP & mySQL (sub-point-versions)

This routine will allow you to update to the latest PHP version running 7.4 such as 7.4.6 to 7.4.11, and also includes mySQL 5.7.x to 5.7.x> Using SSH Using “php -v” allows you to check the current version For general updates use: sudo apt update […]

1 December 2020

mySQL – Backup and Restore via SSH

Backup SQL database sudo mysqldump -u root -pPASSWORD database > /path/filename.sql Restore a database sudo mysql -u root -pPASSWORD database < /path/filename.sql

12 June 2020

MySQL – PHPMYADMIN

On the Google Cloud Platform (GCP); to access phpmyadmin; Type https://mydomainname/phpmyadmin Login with root and your mysql-root-password (found on your instance page) Add a new Database Click the Database Tab In the Create Database field, enter your new database name and click create. Click the […]