Feed aggregator

Export a MySQL table to a CSV as fast as possible (even for millions of records)

My Tech Blog - Thu, 2015-11-26 15:28

using the mysql query tool from the command line, run a query like this:
SELECT *
    -> INTO OUTFILE '/tmp/weather.csv'
    -> FIELDS TERMINATED BY ','
    -> ENCLOSED BY '"'
    -> ESCAPED BY '\\'
    -> LINES TERMINATED BY '\n'
    -> FROM weather_archive;

this exported 1229798 rows (30 cols) in 4.98 sec ;-)

Install Google Earth on Ubuntu 14.04 64-bit

My Tech Blog - Sat, 2015-02-07 08:46

Since the 64 bit version or GE does install correctly on 64 bit ubuntu, the following will get the job done by installing the 32bit requirements in your 64 bit OS then installs the 32 bit version of GE.

sudo apt-get install libfontconfig1:i386 libx11-6:i386 libxrender1:i386 libxext6:i386 libgl1-mesa-glx:i386 libglu1-mesa:i386 libglib2.0-0:i386 libsm6:i386
cd /tmp && wget sudo" title="http://dl.google.com/dl/earth/client/current/google-earth-stable_current_i386.deb
sudo">http://dl.google.com/dl/earth/client/current/google-earth-stable_current...
dpkg -i google-earth-stable_current_i386.deb
sudo apt-get install -f

Install NOIP Client on your Raspberry Pi Model B

My Tech Blog - Sat, 2015-01-24 17:47

sudo apt-get update -y; sudo apt-get upgrade -y;

read more

Install Drupal on your Raspberry Pi Model B

My Tech Blog - Sat, 2015-01-24 16:29

Installing Drupal 7 on Rpi B - Raspbian with Network & SSH working:

sudo apt-get update -y; sudo apt-get upgrade -y;

read more

Create a headless UPnP/DLNA Renderer in Ubuntu 14.04

My Tech Blog - Tue, 2015-01-06 10:16

You can make your ubuntu 14.04 into a Media renderer quite easily.

sudo apt-get install autoconf automake libtool
sudo apt-add-repository ppa:mc3man/trusty-media
sudo apt-get update
sudo apt-get install libupnp-dev libgstreamer0.10-dev \
gstreamer0.10-plugins-base gstreamer0.10-plugins-good \
gstreamer0.10-plugins-bad gstreamer0.10-plugins-ugly \
gstreamer0.10-ffmpeg \
gstreamer0.10-pulseaudio gstreamer0.10-alsa
sudo apt-get install git
git clone https://github.com/hzeller/gmrender-resurrect.git
cd gmrender-resurrect

read more

Flite Test - FPV Cameras, Mobius to GoPro - TIPS

UAV News - Wed, 2014-03-05 12:59
Flite Test - FPV Cameras, Mobius to GoPro - TIPS David and Alex show you some options for FPV cameras. Mobius Action Cam: http://mobius-actioncam.com/ GoPro: http://gopro.com/cameras For more Flite Test: http://flitetest.com/authors/FliteTest From: FliteTest Views: 301 248 ratings Time: 08:36 More in Education

LPIC-1 102 Securing data with encryption

UAV News - Wed, 2014-03-05 06:23
LPIC-1 102 Securing data with encryption More videos like this online at http://www.theurbanpenguin.com We start in the video looking at SSH, progress through the client certificates and then ssh tunnels. With that under our belts it remains to look at gpg. encrypting data between individuals. We create key pair exchange the public keys and then send encrypted data between the two users. From: theurbanpenguin Views: 108 3 ratings Time: 34:59 More in Education

LPIC-1 102 Setup host security

UAV News - Wed, 2014-03-05 01:41
LPIC-1 102 Setup host security More videos like this online at http://www.theurbanpenguin.com In readiness for the 117-102 exam for your LPIC-1 certification we take a look at objective 110.2 and host security. We can deny logins with /etc/nologin, we can set the shell to /bin/false and we can disable accounts as required. To control access to servers we look at the xinetd format and TCP Wappers.. enjoy From: theurbanpenguin Views: 161 2 ratings Time: 21:11 More in Education

LPIC-1 102 Security Administration

UAV News - Tue, 2014-03-04 13:50
LPIC-1 102 Security Administration More videos like this online at http://www.theurbanpenguin.com We start of using find to locate suid files and sgid files in the Linux file ssystem. We then move into passwd aging with chage and passwd. frome there we look at a little su and sudo and edit the /etc/sudoers file. Finished off with a little nmap port scanning. From: theurbanpenguin Views: 274 4 ratings Time: 23:58 More in Education

LPIC-1 102 Network troubleshooting

UAV News - Tue, 2014-03-04 10:27
LPIC-1 102 Network troubleshooting More videos like this online at http://www.theurbanpenguin.com In this video we look at adding in static routes and using basic CLI tools to determine the state of the Network. We will be working at the command line of our Ubuntu 12.104 server for this objective 109.3. From: theurbanpenguin Views: 271 3 ratings Time: 07:44 More in Education

LPIC-1 102 Basic Network Configuration

UAV News - Tue, 2014-03-04 05:45
LPIC-1 102 Basic Network Configuration More videos like this online at http://www.theurbanpenguin.com 109.2 looks at the basic network configuration, the files that store the information and how we can set static and DHCP addresses. Name resolution can be by way of DNS or local files and the order in which they are resolved is don to the /etc/nsswitch file From: theurbanpenguin Views: 305 3 ratings Time: 14:51 More in Education

LPIC-1 Fundamentals of internet protocols

UAV News - Tue, 2014-03-04 01:57
LPIC-1 Fundamentals of internet protocols More videos like this online at http://www.theurbanpenguin.com In this video we look at how the internet works in a nutshell or 20 minutes, what ever comes first. A quick look at IP addressing the IP protocol, ICMP, TCP, UDP and /etc/services. All dressed of with a little netsat , ftp and telnet From: theurbanpenguin Views: 286 3 ratings Time: 21:20 More in Education

Flite Test - 3 Pilots 1 Plane

UAV News - Mon, 2014-03-03 17:26
Flite Test - 3 Pilots 1 Plane Three pilots, each operating separate controls, attempt to fly one airplane! More details and links here: http://flitetest.com/articles/3-pilots-1-plane Stay tuned for more details about Flite Fest 2014. We'll be posting more information here and on our website. Subscribe to keep up to date and stop by the website for more details! http://www.flitetest.com Thanks for your support! Starring: Josh Bixler, Alex Zvada, Eric Monroe Crew: Dave Knop, Austin...

LPIC-1 102 Printing

UAV News - Mon, 2014-03-03 10:34
LPIC-1 102 Printing More videos like this online at http://www.theurbanpenguin.com In this video tutorial we look at configuring printing on your server or desktop. If we edit the cups configurations file we can allow access from other hosts both for printing and management. The management is through the web browser so we have common GUI tools across all distributions as this is part of cups not any one distro. From: theurbanpenguin Views: 322 5 ratings Time: 09:18 More in Education

XenServer Reduce Template Disk Size

UAV News - Mon, 2014-03-03 04:58
XenServer Reduce Template Disk Size More videos like this online at http://www.theurbanpenguin.com The minimum disk size for Linux templates in Xenserver appears to be 8Gb, which is reasonable, but if you need less space especially on expensive sshd then this video howto may help as I reduce it to 4 GB From: theurbanpenguin Views: 268 1 ratings Time: 04:44 More in Education

End of year retrospective and a look forward to 2014

UAV News - Wed, 2014-01-01 02:27
It's out with 2013 and in with 2014 here at RCModelReviews, although I make this video while wearing both my YouTube hats (XJet and RCModelReviews). A big thanks to all those who watch these videos, all the companies who support what I do by making the good and bad products I review and to everyone else who has contributed, directly or indirectly, to these channels. Unfortunately, at this stage, 2014 is looking as if it'll be another year of bench-videos but I'll do my best to keep them...

Solaris 11 Using Roles with RBAC

UAV News - Tue, 2013-12-31 09:46
Solaris 11 Using Roles with RBAC More videos like this online at http://www.theurbanpenguin.com Using RBAC and Roles in oracle Solaris 11 is designed around the least privileged security mod-el. Giving users the minimum rights they need to be able to accomplish their task. I am always shocked by how many system administrators are prepared to give developers the root password because they ask for it! In this tutorial we will look at how we can use to root role without having access to the...

Solaris 11 RBAC for Password Management

UAV News - Mon, 2013-12-30 13:52
Solaris 11 RBAC for Password Management More videos like this online at http://www.theurbanpenguin.com In this video we look at how we can create local profiles to delegate authorizations for password management. This can be daunting but breaking it down we see that this is quite simple. From: theurbanpenguin Views: 0 0 ratings Time: 05:26 More in Education

Flite Test - RC FPV Kit - OVERVIEW

UAV News - Mon, 2013-12-30 12:57
Flite Test - RC FPV Kit - OVERVIEW Check out the beginner FPV system from Ready Made RC here: http://www.readymaderc.com/store/index.php?main_page=product_info&cPath=4_318&products_id=1968 $10 discount code for Flite Test viewers: FLITETEST10 More Flite Test here: http://flitetest.com/authors/FliteTest More on the Versa Wing here: http://flitetest.com/articles/ft-versa-wing From: FliteTest Views: 301 36 ratings Time: 11:57 More in Education

Solaris 11 Rights and Privileges

UAV News - Mon, 2013-12-30 10:25
Solaris 11 Rights and Privileges More videos like this online at http://www.theurbanpenguin.com Of course file system rights still come into play in Solaris 11. When we look at the /etc/shadow file though the permission are read only even to root. To write to the file we use a privileges granted to the root role and we gain access to the root role when running the passwd program that has the SUID bit set.We use the ppriv and pcred command to see this at work. From: theurbanpenguin Views: 0...

Pages

Subscribe to www.spyd.com aggregator