backing up android device using adb [closed]
Execute on your computer adb backup -apk -shared -all This should hopefully create backup.ab with all of your apps, OS, and data. To restore, execute the following. adb restore backup.ab
backup
How do you back up your development machine? [closed]
There’s an important distinction between backing up your development machine and backing up your work. For a development machine your best bet is an imaging solution that offers as near a “one-click-restore” process as possible. TimeMachine (Mac) and Windows Home Server (Windows) are both excellent for this purpose. Not only can you have your entire … Read more
Adb backup does not work
Rather than trying to find an old version of adb, it’s easier to add quotes to the arguments to adb backup : adb backup “-apk -shared -all -f C:\Users\NAME\backup.ab”
Rsync how to include directories but not files?
rsync -a –include=”*/” –exclude=”*” source/ destination/ Basically, first include all directories, then exclude all files.
Backup of PostgreSQL database design – without data
You can use this from psql(terminal): pg_dump -s databasename > file.dump from pg_dump documentation the “-s” dump only the object definitions (schema), not data. pg_dump documentation
Best method for PostgreSQL incremental backup
Update: Check out Barman for an easier way to set up WAL archiving for backup. You can use PostgreSQL’s continuous WAL archiving method. First you need to set wal_level=archive, then do a full filesystem-level backup (between issuing pg_start_backup() and pg_stop_backup() commands) and then just copy over newer WAL files by configuring the archive_command option. Advantages: … Read more
SQL-Server: Is there a SQL script that I can use to determine the progress of a SQL Server backup or restore process?
I found this sample script here that seems to be working pretty well: SELECT r.session_id , r.command , CONVERT(NUMERIC(6,2), r.percent_complete) AS [Percent Complete] , CONVERT(VARCHAR(20), DATEADD(ms,r.estimated_completion_time,GetDate()),20) AS [ETA Completion Time] , CONVERT(NUMERIC(10,2), r.total_elapsed_time/1000.0/60.0) AS [Elapsed Min] , CONVERT(NUMERIC(10,2), r.estimated_completion_time/1000.0/60.0) AS [ETA Min] , CONVERT(NUMERIC(10,2), r.estimated_completion_time/1000.0/60.0/60.0) AS [ETA Hours] , CONVERT(VARCHAR(1000), (SELECT SUBSTRING(text,r.statement_start_offset/2, CASE WHEN r.statement_end_offset … Read more
Is copying the /var/lib/mysql directory a good alternative to mysqldump?
Yes Yes if the table is using the MyISAM (default) engine. Not if it’s using InnoDB. Probably not, and if there is, you just need to execute mysql_upgrade to fix them To avoid getting databases in a inconsistent state, you can either shutdown MySQL or use LOCK TABLES and then FLUSH TABLES before the backup. … Read more
rsync prints “skipping non-regular file” for what appears to be a regular directory
Are you absolutely sure those individual files are not symbolic links? Rsync has a few useful flags such as -l which will “copy symlinks as symlinks”. Adding -l to your command: rsync -rtvpl /source/backup /destination I believe symlinks are skipped by default because they can be a security risk. Check the man page or –help … Read more