Body Cleanse
What happened between 1950 and 2020
Measure Success
Digital Future
Email like a boss!
CleverDog Wifi Camera Stuck on Adding Camera
Do you just purchase a new clever dog wifi home security camera. Is it stuck on trying to add device? The manual does not mention it, but your Wifi network security setting must be setup as WPA2 for the camera to work. Most routers by default are setup for WPA which will not work. Cheers.
Insane Camping
Create MySQL DB From Command Line And Import Data
CREATE USER <dbname>@localhost;
SET PASSWORD FOR <dbuser>@localhost= PASSWORD(“<db_password>”);
GRANT ALL PRIVILEGES ON <dbname>.* TO <dbuser>@localhost IDENTIFIED BY ‘<db_password>’;
FLUSH PRIVILEGES;
source <data_file>.sql;
SQL SERVER – Restore Database Backup using SQL Script (T-SQL)
Database YourDB has full backup YourBaackUpFile.bak. It can be restored using following two steps.
Step 1: Retrive the Logical file name of the database from backup.
RESTORE FILELISTONLY
FROM DISK = 'D:BackUpYourBaackUpFile.bak'
GO
Step 2: Use the values in the LogicalName Column in following Step.
----Make Database to single user Mode
ALTER DATABASE YourDB
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
----Restore Database
RESTORE DATABASE YourDB
FROM DISK = 'D:BackUpYourBaackUpFile.bak'
WITH MOVE 'YourMDFLogicalName' TO 'D:DataYourMDFFile.mdf',
MOVE 'YourLDFLogicalName' TO 'D:DataYourLDFFile.ldf'
/*If there is no error in statement before database will be in multiuser
mode.
If error occurs please execute following command it will convert
database in multi user.*/
ALTER DATABASE YourDB SET MULTI_USER
GO
Export files in a commit in GIT. Just like SVN Export Files in Tortoise
git diff-tree -r --no-commit-id --name-only --diff-filter=ACMRT $commit_id | xargs tar -rf mytarfile.tar