https://windows.php.net/downloads/releases/archives/

Backup-----

mysqldump -u root -ppasse --opt mysiepvr -h 127.0.0.1 > backup-mysiepvr-19.sql


Restore-----
mysql -u root -ppasse -h 127.0.0.1 -D mysiepvir < backup-mysiepvir-19.sql

mysqldump mysiedocsigner annuaures > annuaire.sql

mysqldump -u root -ppasse -h 127.0.0.1 mysiedocertifier annuaires > annuaires.sql

https://mex.e-gams.com/Smart-PS-SRC61.7z
https://mex.e-gams.com/Smart-PSC-SRC6.7z

Tools-------------

 #C:\laragon\bin\mysql\mariadb-10.6.7-winx64\bin
 # mysqld --tc-heuristic-recover=ROLLBACK


mysqlcheck -u root -p passe --all-databases

mysqlcheck -c mydccinterop
--To Repair the Database:
mysqlcheck -u root -p --auto-repair mydccinterop
--You can combine check, optimize and repair functionality together using “–auto-repair”
--To Repair one table from the Database:
mysqlcheck -r mydccinterop tbl_name
mysqlcheck --auto-repair -c -o mydccinterop


mysqldump --user=root --passe --lock-tables --all-databases > /data/backup/mydccinterop_.sql  -$(date +'%Y%m%d_%H%M%S').sql

--dump-date


mysqldump -u username -p --databases db_larry db_curly db_moe > file_name.sql

mysqldump -u root -pmypassword wpdb --tables thetable --where="date_created > '2017-04-27'" > wpdb_myrecord.sql

mysqldump -u root -p database_name | mysql -h remote_host -u root -p remote_database_name


https://ec.europa.eu/health/documents/community-register/html/
 
 https://github.com/ehn-dcc-development/ehn-dcc-valuesets/blob/main/vaccine-medicinal-product.json
 https://github.com/admin-ch/CovidCertificate-Examples/blob/main/valuesets/vaccine-medicinal-product.json
 
 https://data.public.lu/fr/datasets/europe-ehealth-network-digital-covid-certificate-payload/

 https://apps.who.int/iris/bitstream/handle/10665/343361/WHO-2019-nCoV-Digital-certificates-vaccination-2021.1-eng.pdf?sequence=1&isAllowed=y
 https://www.digitaler-impfnachweis-app.de/en/vaccination-certificate-service/
 
 
 
 
 
 COVID-19 vaccine marketing authorization holder or manufacturer
 INSERT INTO `vaccine_marketing_manufacturers` (`id`, `code`, `name`, `lang`, `url`, `system_oid`, `version`, `created_at`, `updated_at`) 
 VALUES (NULL, 'ORG-100001981', 'Covishield', 'en', NULL, NULL, NULL, NULL, NULL);
 
 
 Vaccine Medical Prod
 INSERT INTO `vaccine_medicinals` (`id`, `code`, `name`, `lang`, `system`, `version`, `created_at`, `updated_at`) 
 VALUES (NULL, 'Covishield', 'Covishield', 'en', '', '', NULL, NULL),
 VALUES (NULL, 'ORG-100000788', 'Sanofi Pasteur ', 'en', NULL, NULL, NULL, NULL, NULL);