Futilities/server/dba: Difference between revisions
< Futilities | server
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{fmt/title|DBA: Database Administration}} | {{fmt/title|DBA: Database Administration}} | ||
== | ==Usage== | ||
For current command definitions, see [Fu]config/ready/{{arg|config name}}/dba/ui.xml | |||
* 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] | |||
Example commands (run from inside the <code>futils/run/dba</code> folder): | Example commands (run from inside the <code>futils/run/dba</code> folder): | ||
{| class=wikitable | {| class=wikitable | ||
| Line 8: | Line 11: | ||
| lists all the databases found in the local configuration | | lists all the databases found in the local configuration | ||
|- | |- | ||
| <code>./go fplocal:'/home/woozle/Downloads/ | | <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 | | 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
|