Want to try livestreaming to Twitch.tv? OBS is free and it seems to work for most everyone.
Here was the catch for me:
1. Reboot after installing.
2. After you start your game, run OBS (the 32 bit version). Then, add a “Game Capture” source. When I added it before I started the game, I never saw the game in the drop-down.
For configs, I did the step-by-step on the Twitch.tv site here: http://ift.tt/1c5mEuk
Or just start here: http://ift.tt/OSXKWU
My Twitch.tv screen name is capnjosh1.
It’s some research that shows *how* certain bacteria influence your body’s fat-storing activities.
The study:
The blog mentioning the study:
“Using next-generation sequencing technology, the researchers also were able to detect hundreds of unique bacterial species and confirmed that children with ASD harbored distinct and less diverse gut bacterial composition.”
Here’s the article (more like a press release):
Here’s the interview with some of the authors (I love Youtube):
A blog that seems to post links to loads of Autism studies and papers:
You have a full backup of all databases on a MySQL instance and you want to restore only a single Database from that full backup (rather than all the DBs).
Here’s how (use “cat” instead of “zcat” if your full backup is not compressed with gzip:
zcat path_to_full_mysqldump_Backup | sed -n -e ‘/Current Database:.*`characters/,/Current Database:/p’ | mysql -h ip_of_server_you_want_to_restore_to -P port_of_server_instance_you_want_to_restore_to –protocol=tcp -u mysql_username_on_server_you_want_to_restore_to -p –database=name_of_database_you_want_to_restore_to
If you want to test the output before running it remove the “mysql….” at the end of the line and dump it to a text file like this:
zcat path_to_full_mysqldump_Backup | sed -n -e ‘/Current Database:.*`characters/,/Current Database:/p’ > testingout.sql
Then look at the first 20 lines or so to ensure there are statements that create the expected database, and then look at the last line to ensure there are no more statements regarding creation of a different DB (you will likely see a big insert statement for the last line).
You need to restore a single table, but you only have a full db dump from MySQL, and you can’t dump a fresh copy of the table.
Here’s an example one-liner that restores a single given table from a given full db dump to a given server instance. You can change the “zcat” to just “cat” if you didn’t use gzip to compress it.
zcat path_to_full_GameDB_Slave_Instance_Backup_you_want_to_push_to_PTS | sed -n -e ‘/Table structure for.*`name_of_table_you_want_to_restore/,/Table structure for/p’ | mysql -h ip_of_server_you_want_to_restore_to -P port_of_server_instance_you_want_to_restore_to –protocol=tcp -u mysql_username_on_server_you_want_to_restore_to -p –database=name_of_database_you_want_to_restore_to
Reference:
