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

Copying files between remote machines can be easily done
using SCP command.

The syntax is:

copy from a remote machine to my machine:

scp user@192.168.0.1:/home/file.txt /home/x.txt

copy from my machine to a remote machine:

scp /home/x.txt user@192.168.0.1:/home/x.txt

copy all x*.txt from a remote machine to my machine (x01.txt, x02.txt, etc.)

scp “user@192.168.0.1:/home/x*.txt” /home/x.txt

copy a directory from a remote machine to my machine:

scp -r user@192.168.0.1:/home/folder /home/

Tags: Command, copy, Copying, Definitions, directory, div, file, folder, Home, machine, margin, MsoNormal, MsoNormalTable, New, page, SCP, Section, Simple, size, SSH, Style, syntax, Times, txt, user

Remote Desktop is disabled by default in Windows Vista, but it’s easy enough to turn it back on. If you need to access your Vista PC from another box, it’s an essential thing to turn on.

To get to the configuration page, you can either right-click the Computer icon and choose properties, or you can type in system into the start menu search box, and then System.

Now you’ll want to click the Remote Settings link on the left hand side.

Check “Allow Remote Assistance connections to this computer” and “Allow connections from computers running any version of Remote Desktop” (this means that you can access your remote computer using Windows XP also).

Note: This will not work for Home editions of Windows Vista. Read the rest of this entry »

Tags: Assistance, box, calculator, click, computer, configuration, Control, conversion, CurrentControlSet, Decimal, default, Desktop, Edit, Editor, hand, hex, HKEY, Home, icon, left, link, LOCAL, Locate, machine, menu, Modify, Note, number, page, Port, RDP-Tcp, registry, Remote, search, Server, Settings, side, start, subkey, System, Terminal, thing, tool, Type, value, version, Vista, Windows, WinStations