There is a time when you need to export a specific table from a mysql database. Through SSH this is made very easy using the following command:

echo “select * from table_name;” | mysql -u root -pyourpassword database_name | sed -e ’s/^Mn/r/g’ > /home/exported.csv

Of course you can make a small script that adds the date or other usefull information to the filename:

#!/bin/bash
#This scripts adds date to the exported CSV
NOW=$(date +”%m_%d_%Y_%H_%M_%S”)
echo “select * from table_name;” | mysql -u root -pyourpassword database_name | sed -e ’s/^Mn/r/g’ > /home/exported_$NOW.csv

Save this script as export_csv.sh and make it executable, and that’s it.

Tags: bash, bin, Command, course, csv, database, date, export, filename, Home, information, Linux, mysql, pyourpassword, root, script, SQL, SSH, table, time, Ubuntu, usefull

I usually dual boot my PC with Windows and Linux. For the moment I still heavily use Windows so most of my information is stored on NTFS drives. My linux ext3 partition is only 10 GB wich is more than enough. But I recently installed VMware server on Ubuntu Hardy Heron, and obviously I was forced to save my virtual machines on one of the larger windows partitions. That was o problem for my system, because everything I did I couldn’t PowerOn the virtual machine, with the following error message: “Unable to connect to the MKS: Pipe: Read failed.” After a lot of searching I found this solution. Edit as root the main .vmx file and add this line:

mainMem.useNamedFile=FALSE

Save it and you are ready to use your virtual machine.

Tags: boot, Edit, error, everything, ext, FALSE, file, Hardy, Heron, information, line, Linux, lot, main, mainMem, message, MKS, moment, NTFS, partition, Pipe, PowerOn, problem, Read, root, Server, solution, System, Ubuntu, Unable to connect to the MKS: Pipe: Read failed, useNamedFile, VMware, vmx, wich

I have a Dell Inspiron 1520 with the Dell Wireless 1390 WLAN Mini-Card, one that has given many Linux users big headaches.

After trying many different approaches suggested all over the web, and gathering clues in many Ubuntu forum posts, I finally worked out this solution:

First of all you must check if you have the correct card:

lspci -nn | grep 14e4

Result: 05:00.0 Network controller [0280]: Broadcom Corporation BCM94311MCG wlan mini-PCI [14e4:4311 (rev 01)]

Then proceed to the first step:

1. blacklist bcm43xx

echo blacklist bcm43xx | sudo tee -a /etc/modprobe.d/blacklist

2. install ndiswrapper and related files

sudo apt-get install ndiswrapper-common ndiswrapper-utils-1.9 ndisgtk

Read the rest of this entry »

Tags: 1390, bcm, bcmwl, bit, bloat, bunch, card, Dell Inspiron, Dell Wireless, DHCP, download, DRIVER, folder, forum, gathering, Hardy, Heron, INF, Linux, machine, minicard, modprobe, ndisgtk, ndiswrapper, package, reboot, result, side, solution, sudo, tee, the, Ubuntu, US, use, Web, wireless, wlan

When volume of the sound captured is too low, even with system sound volume set to maximum level, do the following:

1. Open the GNOME volume control tool:

$ gnome-volume-control

2. Select Edit -> Preferences and verify the following tracks are visible: PCM, Front, Capture, Mux and Digital. Click Close when done.

3. In the Options tab, verify that the Input Source is set to “Mic”.

4. To maximize volume of recorded sound: In the Recording tab, adjust the “Capture”, “Mix” and “Digital” sliders higher to raise the volume level of the captured audio. Click on the microphone icon on the bottom if it has a red cross on it to unmute it.

5. To maximize volume of playback sound: In the Playback tab, adjust the “PCM”, “Front” and “Surround” sliders higher to raise the volume level.

When the overall sound volume is too low, you should:

1. Right click on speaker icon in system tray, and select “Open Volume Control”

2. Go to Edit: Preferences

3. Put a check next to Front. Hit OK

4. Turn Front volume all the way up.

5. Now the master volume control raises and lowers the volume between much greater extremes.

Tags: 1520, bottom, Capture, check, click, Close, Control, cross, Dell, Digital, Edit, Front, GNOME, gutsy, Hardy, icon, Input, Inspiron, level, Linux, low, master, Maximum, Mic, microphone, Mix, Mux, Open, PCM, playback, Recording, Select, sound, Source, speaker, Surround, System, tab, tool, tray, Turn, Ubuntu, unmute, volume, way