If you can cope with table-at-a-time, and your data is not binary, use the -B option to the mysql command. With this option it’ll generate TSV (tab separated) files which can import into Excel, etc, quite easily: % echo ‘SELECT * FROM table’ | mysql -B -uxxx -pyyy database Alternatively, if you’ve got direct access … Read more
I would strongly advise against putting unrelated data in a given Git repository. The overhead of creating new repositories is quite low, and that is a feature that makes it possible to keep different lineages completely separate. Fighting that idea means ending up with unnecessarily tangled history, which renders administration more difficult and–more importantly–“archeology” tools … Read more
As per https://android.stackexchange.com/a/78183/239063 you can run a one line command in Linux to add in an appropriate tar header to extract it. ( printf “\x1f\x8b\x08\x00\x00\x00\x00\x00” ; tail -c +25 backup.ab ) | tar xfvz – Replace backup.ab with the path to your file.
Okay, Technoob1984 here with the scoop. See my attached screen shot. This one is tricky, because you have to use x64 version of Powershell (located under system32 not wow64) The Shadow Copy Context are the .properties of the object. Also I used the static method in my screenshots below. https://learn.microsoft.com/en-us/previous-versions/windows/desktop/vsswmi/create-method-in-class-win32-shadowcopy # get existing shadow copies … Read more
To backup a single database from the command line, use osql or sqlcmd. “C:\Program Files\Microsoft SQL Server\90\Tools\Binn\osql.exe” -E -Q “BACKUP DATABASE mydatabase TO DISK=’C:\tmp\db.bak’ WITH FORMAT” You’ll also want to read the documentation on BACKUP and RESTORE and general procedures.
Use this: find . -type f -print0 | tar -czvf backup.tar.gz –null -T – It will: deal with files with spaces, newlines, leading dashes, and other funniness handle an unlimited number of files won’t repeatedly overwrite your backup.tar.gz like using tar -c with xargs will do when you have a large number of files Also … Read more
I added the following 2 parameters: /np /nfl So together with the 5 parameters from AndyGeek’s answer, which are /njh /njs /ndl /nc /ns you get the following and it’s silent: ROBOCOPY [source] [target] /NFL /NDL /NJH /NJS /nc /ns /np /NFL : No File List – don’t log file names. /NDL : No Directory … Read more
Let’s take a look at how rsync works and better understand the cryptic result lines: 1 – A huge advantage of rsync is that after an interruption the next time it continues smoothly. The next rsync invocation will not transfer the files again, that it had already transferred, if they were not changed in the … Read more
The sqlite3 command line tool features the .backup dot command. You can connect to your database with: sqlite3 my_database.sq3 and run the backup dot command with: .backup backup_file.sq3 Instead of the interactive connection to the database, you can also do the backup and close the connection afterwards with sqlite3 my_database.sq3 “.backup ‘backup_file.sq3′” Either way the … Read more