Install phpmyadmin on pi raspbian bullseye

 cf: http://linux.how2shout.com/how-to-install-phpmyadmin-on-debian-11-bullseye-apache/

1. sudo apt -y install php-cgi php-mysqli php-pear php-mbstring libapache2-mod-php php-common php-phpseclib php-mysql
2. wget https://www.phpmyadmin.net/downloads/phpMyAdmin-latest-all-languages.tar.gz
3. sudo tar xvf phpMyAdmin-latest-all-languages.tar.gz
4. sudo mv phpMyAdmin-*-all-languages/ /var/www/html/phpmyadmin
5. cd /var/www/html
sudo cp phpmyadmin/config.sample.inc.php phpmyadmin/config.inc.php
6. sudo mkdir /var/www/html/phpmyadmin/tmp
7. openssl rand -base64 32
(copy the output key)
8. sudo vim /var/www/html/phpmyadmin/config.inc.php
9. Put the key in Step 6 into:
$cfg[‘blowfish_secret’] = ‘your-key‘; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
10. And add this line:
$cfg['TempDir'] = '/var/www/html/phpmyadmin/tmp';
11. sudo chown -R www-data:www-data /var/www/html/phpmyadmin
12. sudo vim /etc/apache2/conf-available/phpmyadmin.conf
13. Add the followings:
Alias /phpmyadmin /var/www/html/phpmyadmin

<Directory /var/www/html/phpmyadmin/>
   AddDefaultCharset UTF-8
   <IfModule mod_authz_core.c>
          <RequireAny>
      Require all granted
     </RequireAny>
   </IfModule>
</Directory>

<Directory /var/www/html/phpmyadmin/setup/>
   <IfModule mod_authz_core.c>
     <RequireAny>
       Require all granted
     </RequireAny>
   </IfModule>
</Directory>
14. sudo a2enconf phpmyadmin.conf
15. sudo systemctl restart apache2


php stuff in pi4

1. sudo apt purge php*
2. sudo apt install php8.0
3. sudo apt install php8.0-mysql
   sudo apt install php8.0-dom
   sudo apt install php8.0-mbstring
   sudo apt install php8.0-fpm
   sudo apt install php8.0-pear
   sudo apt install php-pear
   

Clone drupaldam to pi4

1. Open Backup and Migration in http://kpcp4.au.edu.tw/~chiao/drupaldam/dam/web/. Backup all tables and save it as backup_kpci7_drupaldam.sql.gz
   
2. gzip -d backup_kpci7_drupaldam.sql.gz > backup_kpci7_drupaldam.sql
3. sed 's/utf8mb4_0900_ai_ci/utf8mb4_unicode_ci/g' backup_kpci7_drupaldam.sql > backup_kpci7_drupaldam_unicode.sql
4. Open Backup and Migration in https://192.168.1.14/~chiao/drupaldam/dam/web/. Restore as with the file backup_kpci7_drupaldam_unicode.sql
5. Done.