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
Line 1: Line 1:
{{fmt/title|DBA: Database Administration}}
{{fmt/title|DBA: Database Administration}}
==Notes==
==Notes==
Example command (run from inside the <code>futils/run/dba</code> folder):
Example commands (run from inside the <code>futils/run/dba</code> folder):
./go fplocal:'/home/woozle/Downloads/scratch' xfmode:sql read:hetz1
{| class=wikitable
* makes SQL backup of the "hetz1" remote database, using '/home/woozle/Downloads/scratch' as the root folder for output files
! command || description
|-
| <code>./go list
| lists all the databases found in the local configuration
|-
| <code>./go fplocal:'/home/woozle/Downloads/scratch' 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
|}

Revision as of 14:21, 4 December 2024

DBA: Database Administration

Notes

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/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