Helper Scripts » History » Revision 4
« Previous |
Revision 4/15
(diff)
| Next »
Enis Nuredini, 23.08.2023 10:47
Helper Scripts¶
tear_down_project.py (Backup project folder and both DBs)
Functionality: Creating backup file from project folder and databases (data and typo3). Transfering files to /scratch/tmp/365/. Comprimising all files in one tar. Deleting all created files during this process (except the summary tar file).
Requirement: User should have ssh keys for the affected server hosts.
Configuration: In the top of the script the project and database host can be written. Path to the ssh keys is set as default.
table_groupmember_reference_transfer (Transfer specific records from DB1 to DB2)
Functionality: User given argument will be searched in configured column (default: reference) from table (default: GroupMember). All found records are transfered from source DB to target DB. If record with given argument exists on target DB then UPDATE statement is executed, otherwise INSERT statement.
Requirement: Table structure from source and target DB must be identical. Date and datetime defaults, if nothing given in source record needs to be NULL, otherwise mysql outputs an error.
Configuration: DB-users, hostnames and affected table or column can be set inside the script.
Updated by Enis Nuredini 11 months ago · 4 revisions