Futilities/server/dba: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
(Created page with "{{fmt/title|DBA: Database Administration}} ==Notes== Example command (run from inside the <code>futils/run/dba</code> folder): ./go fplocal:'/home/woozle/Downloads/scratch' xfmode:sql read:hetz1 * makes SQL backup of the "hetz1" remote database, using '/home/woozle/Downloads/scratch' as the root folder for output files")
 
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{fmt/title|DBA: Database Administration}}
{{fmt/title|DBA: Database Administration}}
==Notes==
==Usage==
Example command (run from inside the <code>futils/run/dba</code> folder):
For current command definitions, see [Fu]config/ready/{{arg|config name}}/dba/ui.xml
./go fplocal:'/home/woozle/Downloads/scratch' xfmode:sql read:hetz1
* Examples in "scooter": [https://gitlab.com/woozalia/ferreteria/-/blob/v0.6/apps/futils/config/ready/scooter/dba/ui.xml v0.6], [https://gitlab.com/woozalia/ferreteria/-/blob/v0.6-best/apps/futils/config/ready/scooter/dba/ui.xml?ref_type=heads v0.6-best], [https://gitlab.com/woozalia/ferreteria/-/blob/v0.6-dev/apps/futils/config/ready/scooter/dba/ui.xml?ref_type=heads v0.6-dev]
* makes SQL backup of the "hetz1" remote database, using '/home/woozle/Downloads/scratch' as the root folder for output files
 
Example commands (run from inside the <code>futils/run/dba</code> folder):
{| class=wikitable
! command || description
|-
| <code>./go list
| lists all the databases found in the local configuration
|-
| <code>./go fplocal:'/home/woozle/Downloads/backups' xfmode:sql read:hetz1</code>
| makes SQL backup of the "hetz1" remote database, using <code>/home/woozle/Downloads/scratch</code> as the root folder for output files
|}

Latest revision as of 19:02, 7 October 2025

DBA: Database Administration

Usage

For current command definitions, see [Fu]config/ready/<config name>/dba/ui.xml

Example commands (run from inside the futils/run/dba folder):

command description
./go list lists all the databases found in the local configuration
./go fplocal:'/home/woozle/Downloads/backups' xfmode:sql read:hetz1 makes SQL backup of the "hetz1" remote database, using /home/woozle/Downloads/scratch as the root folder for output files