Futilities/server/dba: Difference between revisions
< Futilities | server
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
| Line 8: | Line 8: | ||
| 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 00:22, 5 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/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
|