The command docker commit takes a snapshot of your container. That snapshot is an image, which you can put on a (private) repository to be able to pull it on another host. An option that does not use an image (which you say you want to avoid) is indeed save and load. According to the … Read more
It looks like the SQL Server doesn’t have permission to access file C:\backup.bak. I would check the permissions of the account that is assigned to the SQL Server service account. As part of the solution, you may want to save your backup files to somewhere other that the root of the C: drive. That might … Read more
Okay, here is a solution to reduce the physical size of the transaction file, but without changing the recovery mode to simple. Within your database, locate the file_id of the log file using the following query. SELECT * FROM sys.database_files; In my instance, the log file is file_id 2. Now we want to locate the … Read more
I have very large databases with tens of thousands of tables some of which have up to 5GB of data in 10’s of millions of entries. (I run a popular service)… I’ve always had headaches when backing up these databases. Using default mysqldump it quickly spirals the server load out of control and locks up … Read more
By default mysqldump always creates the CREATE DATABASE IF NOT EXISTS db_name; statement at the beginning of the dump file. [EDIT] Few things about the mysqldump file and it’s options: –all-databases, -A Dump all tables in all databases. This is the same as using the –databases option and naming all the databases on the command … Read more
Thank you, user374559 and reneD — that code and description is very helpful. My stab at some Python to parse and print out the information in a Unix ls-l like format: #!/usr/bin/env python import sys def getint(data, offset, intsize): “””Retrieve an integer (big-endian) and new offset from the current offset””” value = 0 while intsize … Read more
I just set up a good solution for this, it requires dropbox. I am currently using this to sync plugins and settings across ~5 different sublime installs on windows, linux, osx, and a few vm’s. Step 1: use PackageControl to manage all your plugins, its awesome. Step 2: Add a “Sublime” directory to your root … Read more
Security researchers Jean-Baptiste Bédrune and Jean Sigwald presented how to do this at Hack-in-the-box Amsterdam 2011. Since then, Apple has released an iOS Security Whitepaper with more details about keys and algorithms, and Charlie Miller et al. have released the iOS Hacker’s Handbook, which covers some of the same ground in a how-to fashion. When … Read more
You cannot use the BACKUP DATABASE command to backup a single table, unless of course the table in question is allocated to its own FILEGROUP. What you can do, as you have suggested, is export the table data to a CSV file. Now in order to get the definition of your table you can ‘Script … Read more
First check that you are getting reasonable IO performance from your disk setup. Then check that you PostgreSQL installation is appropriately tuned. In particular shared_buffers should be set correctly, maintenance_work_mem should be increased during the restore, full_page_writes should be off during the restore, wal_buffers should be increased to 16MB during the restore, checkpoint_segments should be … Read more