ksh nice prompt

export PS1=$host.$LOGNAME:$PWD:`id`:`echo ``date +%Y.%m.%d-%H:%M:%S`` `:`echo  "\n" $ " "`

cas 0.5.0 out now

download project

how-to import a mssql db from exported csv files per table

download project

cas 0.5 out now

Download project

how-to copy folder structure with robocopy

robocopy d:\source\dir\ d:\dest\dir\ /create /E /max:1

CAS version 0.4.3 out now

Download

CAS version 0.4.2 out now 20100820_221331

Download project

Fusion links

1. Focus Fusion 
2. Polywell  
3. Los Alamos
4. NIF 
5. Hiper
6. Iter 
7. General Fusion 

how-to generically deploy MSSQL schema and RollBack db from file

Download Project

CAS goes public ...

Download project

Unzip to a folder ( no spaces !!!)
Open Istall_CAS_DEV.cmd and set up vars
Double - click ...

More in the near future ...

how-to check md5 sums on windows and unix , linux

echo on UNix
find /dir/path -type f -name ="*zip" -exec md5sum {} \; >> md5CheckSums.log

echo on Windows
for /f %i in ( 'dir *.zip /b') do echo %i , >>log.md5sums.csv&md5sum %i>>md5sums.csv&echo.>>md5sums.csv

How-to rollback a MSSQL db from file via command line

Download project

START ===== D:\cas\Sql_dev\sql_dev.0.4.1_20100815_145522\RollBack\RestoreDbFromFile.sql

-- Restore database from file

-----------------------------------------------------------------

use master

go

declare @FileToRollBack varchar(100), @DbFilesBackUpDir varchar(100),

@databaseDataFilename varchar(100), @databaseLogFilename varchar(100),

@databaseDataFile varchar(100), @databaseLogFile varchar(100),

@DbNameToRestore varchar(100), @execSql nvarchar(1000)

--'$(_DbFilesBackUpDir)'

-- Set the name of the database to restore

set @DbNameToRestore = '$(_DbNameToRestore)'

-- Set the path to the directory containing the database backup

set @DbFilesBackUpDir =  '$(_DbFilesBackUpDir)' -- such as 'c:\temp\'

-- Create the backup file name based on the restore directory, the database name and today's date

--@FileToRollBack = @DbFilesBackUpDir + @DbNameToRestore + '-' + replace(convert(varchar, getdate(), 110), '-', '.') + '.bak'

declare @DBFileName varchar(256)    

--set @DBFileName = @DbNameToRestore + '_' + replace(convert(varchar, getdate(), 112), '-', '.') + '.bak'

--BOOM BOOM BOOM CHANGE THIS 

set @FileToRollBack = '$(_FileToRollBack)'

-- Get the data file and its path

select @databaseDataFile = rtrim([Name]),

@databaseDataFilename = rtrim([Filename])

from master.dbo.sysaltfiles as files

inner join

master.dbo.sysfilegroups as groups

on

files.groupID = groups.groupID

where DBID = (

select dbid

from master.dbo.sysdatabases

where [Name] = @DbNameToRestore

)

-- Get the log file and its path

select @databaseLogFile = rtrim([Name]),

@databaseLogFilename = rtrim([Filename])

from master.dbo.sysaltfiles as files

where DBID = (

select dbid

from master.dbo.sysdatabases

where [Name] = @DbNameToRestore

)

and

groupID = 0

print 'Killing active connections to the "' + @DbNameToRestore + '" database'

-- Create the sql to kill the active database connections

set @execSql = ''

select @execSql = @execSql + 'kill ' + convert(char(10), spid) + ' '

from master.dbo.sysprocesses

where db_name(dbid) = @DbNameToRestore

and

DBID <> 0

and

spid <> @@spid

exec (@execSql)

print 'Restoring "' + @DbNameToRestore + '" database from "' + @FileToRollBack + '" with '

print ' data file "' + @databaseDataFile + '" located at "' + @databaseDataFilename + '"'

print ' log file "' + @databaseLogFile + '" located at "' + @databaseLogFilename + '"'

set @execSql = '

restore database [' + @DbNameToRestore + ']

from disk = ''' + @FileToRollBack + '''

with

file = 1,

move ''' + @databaseDataFile + ''' to ' + '''' + @databaseDataFilename + ''',

move ''' + @databaseLogFile + ''' to ' + '''' + @databaseLogFilename + ''',

norewind,

nounload,

replace'

exec sp_executesql @execSql

exec('use ' + @DbNameToRestore)

go

-- If needed, restore the database user associated with the database

/*

exec sp_revokedbaccess 'myDBUser'

go

exec sp_grantdbaccess 'myDBUser', 'myDBUser'

go

exec sp_addrolemember 'db_owner', 'myDBUser'

go

use master

go

*/ 

END ================== D:\cas\Sql_dev\sql_dev.0.4.1_20100815_145522\RollBack\RestoreDbFromFile.sql

. 

START ===== D:\cas\Sql_dev\sql_dev.0.4.1_20100815_145522\RollBack\RollBackDbFromFile.cmd

ECHO STARTTING ROLLBACK

ECHO FOR EACH SQL FILE DO RUN IT THIS WILL TAKE A WHILE 

@ECHO OFF

:: DOC AT THE END 

:: AND READS THE COMMENTS BEFORE EACH LINE !!!

:: BOOM BOOM BOOM CHANGE THIS ENVIRONMENT VARIABLES ACCORDING TO YOUR CONFIGURATION SETUP

:: BOOM BOOM BOOM DO NOT ADD EXTRA SPACE BEFORE THE = SIGN IN THE VARS OR AT THE END OF THE LINE !!!

SET _DbName=master

SET _sqlAdminUserName=ysg

SET _hostNameAndInstance=hostName\POC_QA

SET _passwd=pass

SET _MillisecondsToSleep=10

SET _DbFilesBackUpDir=D:\Data\Backups\

SET _FileToRollBack=%_DbFilesBackUpDir%POC_FB_20100331.bak

SET _DbNameToRestore=POC_DEV

ECHO OPEN THIS FILE AND AND SET  THE ENV VARS ACCORDING TO YOUR CONFIGURATION 

set _

pause

CLS

mkdir log 

::DEBUG ECHO FOR EACH SQL FILE DO RUN IT THIS WILL TAKE A WHILE 

ECHO START RESTORE 

for /f %%i  in ('dir *.SQL /s /b /o') do ECHO RUNNING %%i1>>"..\install.log"&SQLCMD -U %_sqlAdminUserName% -P %_passwd% -S %_hostNameAndInstance% -d %_DbName% -t 300 -w 80 -u -p 1 -b -i %%i  -r1 1>> "log\install.log" 2>> "log\error.log" 

ECHO GO ONE FOLDER UP 

cd ..

ECHO SLEEP FOR 1 SECOND 

ping -n 1 127.0.0.1 >NUL

ECHO DONE WITH BACKUP GOING UP 

ECHO Please , Review the log files and sent them back to Advanced Application Support 

cmd /c start /max log\install.log

CMD /C start /MAX log\error.log

echo DONE !!!

ECHO HIT A KEY TO EXIT 

END ================== D:\cas\Sql_dev\sql_dev.0.4.1_20100815_145522\RollBack\RollBackDbFromFile.cmd

. 

START ===== D:\cas\Sql_dev\sql_dev.0.4.1_20100815_145522\RollBack\ZipMe.cmd

@echo off

echo this batch file zips recursively everything from the current directory

echo into one nicely timestamped filename and 

echo this batch files needs the gnu zip utility 

echo google download gnu zip for windows

:: JUST MAKE SURE WE DO NOT HAVE TXTT FILES ANYMORE 

for /f %%i in ('dir *.txtt /s /b') do rename "%%i" *.sql

pause

::GET FROM USER PACKAGE NAME

set /p pkgName=TYPE THE PACKAGE NAME WITH NO SPACES AND HIT ENTER :

:: set the nicetime var

call GetNiceTime.cmd

::delete the previoues zip file 

del /q zipFile.zip

:: add the files into a package

zip -r zipFile *

::debug echo nicetime is %niceTime%

::debug pause

::debug echo rename "%cd%\zipFile.zip" %niceTime%.zip.txt

::debug pause

:: make it a txt file for easier e-mail deleting 

rename "%cd%\zipFile.zip" "%pkgName%_%niceTime%.zip.txt"

google docs upload "%niceTime%.zip.txt" 1>log.log 2>error.log

pause

::debug pause

END ================== D:\cas\Sql_dev\sql_dev.0.4.1_20100815_145522\RollBack\ZipMe.cmd

. 

START ===== D:\cas\Sql_dev\sql_dev.0.4.1_20100815_145522\RollBack\log\error.log

Changed database context to 'master'.

Killing active connections to the "POC_DEV" database

Restoring "POC_DEV" database from "D:\Data\Backups\POC_FB_20100331.bak" with 

data file "POC" located at "D:\Data\POC_DEV.mdf"

log file "POC_log" located at "D:\Data\POC_DEV_1.ldf"

Processed 45352 pages for database 'POC_DEV', file 'POC' on file 1.

Processed 1 pages for database 'POC_DEV', file 'POC_log' on file 1.

RESTORE DATABASE successfully processed 45353 pages in 19.995 seconds (17.720 MB

/sec).

END ================== D:\cas\Sql_dev\sql_dev.0.4.1_20100815_145522\RollBack\log\error.log

. 

START ===== D:\cas\Sql_dev\sql_dev.0.4.1_20100815_145522\RollBack\log\install.log

4096:1:47:47.00:21.28 

4096:1:24961:24961.00:0.04 

4096:1:1:1.00:1000.00 

END ================== D:\cas\Sql_dev\sql_dev.0.4.1_20100815_145522\RollBack\log\install.log

how-to export a MSSQL database to csv files ( one file per table )

Download the project



START ===== C:\Temp\ExportDb.cmd
echo THIS CMD SCRIPT NEEDS SQLCMD IN YOUR PATH
ECHO PURPOSE: EXPORT THE LIST OF ALL TABLES INTO A TABLESLIST NAMED FILE
ECHO AND FOREACH LINE ( A TABLE NAME ) OF THE FILE EXPORT THAT TABLE TO A FILE
@echo off

sqlcmd -S hostName\instance_name -U userName -P password -d DataBaseName -Q "set nocount on;select name from sys.tables" -o "TablesList.csv" -s"|" -u -r1 -e -W -w4000 -h-1 -b -e
for /f %%i in ('type TablesList.csv') do ExportTable.cmd %%i

pause

END ================== C:\Temp\ExportDb.cmd

.
START ===== C:\Temp\ExportTable.cmd
set TableName=%1

sqlcmd -S hostName\poc_qa -U userName -P password -d cas_dev -Q "set nocount on;select * from %TableName%" -o "%TableName%.csv" -s"|" -u -r1 -e -W -w4000 -h-1 -b -e

END ================== C:\Temp\ExportTable.cmd

GetNiceTime.cmd

@echo off
:: START FILE GetNiceTime.cmd ====================================================
:: HAVING THE FOLLOWING DATE TIME FORMATS time is 21:30:27,47 and date is to 20.05.2010
:: START USAGE ==================================================================
:: SET THE NICETIME
:: SET NICETIME=BOO
:: CALL GetNiceTime.cmd
:: ECHO %COMPUTERNAME% GETS HOSTNAME
:: ECHO NICETIME IS %NICETIME%

:: echo nice time is %NICETIME%
:: END USAGE ==================================================================

echo set hhmmsss
:: this is Regional settings dependant so tweak this according your current settings
for /f "tokens=1-3 delims=,: " %%a in ('echo %time%') do set hhmmsss=%%a%%b%%c
for /f "tokens=1-3 delims=,: " %%a in ('echo %time%') do set _hhmmsss=%%a:%%b:%%c
:: DEBUG PAUSE
ECHO hhmmsss IS %hhmmsss%
:: DEBUG PAUSE
echo %yyyymmdd%
:: this is Regional settings dependant so tweak this according your current settings
for /f "tokens=2-4 delims=. " %%D in ('echo %DATE%') do set yyyymmdd=%%F%%E%%D
for /f "tokens=2-4 delims=. " %%D in ('echo %DATE%') do set _yyyymmdd=%%F.%%E.%%D
::DEBUG ECHO yyyymmdd IS %yyyymmdd%
:: DEBUG PAUSE


set NICETIME=%yyyymmdd%_%hhmmsss%
set _NICETIME=%_yyyymmdd% - %_hhmmsss%

:: THIS NEEDS THE CLIP.EXE command line tool from the windows server 2003 resource kit
echo %NICETIME% | CLIP

:: DEBUG PAUSE
echo THE NICETIME IS %NICETIME%
echo THE _NICETIME IS %_NICETIME%
:: DEBUG PAUSE

:: =========END FILE GetNiceTime.cmd ====================================================

how-to get a nice time GetNiceTime.cmd

@echo off
:: START FILE GetNiceTime.cmd ====================================================
:: HAVING THE FOLLOWING DATE TIME FORMATS time is 21:30:27,47 and date is to 20.05.2010
:: START USAGE ==================================================================
:: SET THE NICETIME
:: SET NICETIME=BOO
:: CALL GetNiceTime.cmd

:: ECHO NICETIME IS %NICETIME%

:: echo nice time is %NICETIME%
:: END USAGE ==================================================================

echo set hhmmsss
:: this is Regional settings dependant so tweak this according your current settings
for /f "tokens=1-3 delims=,: " %%a in ('echo %time%') do set hhmmsss=%%a%%b%%c
for /f "tokens=1-3 delims=,: " %%a in ('echo %time%') do set _hhmmsss=%%a:%%b:%%c
:: DEBUG PAUSE
ECHO hhmmsss IS %hhmmsss%
:: DEBUG PAUSE
echo %yyyymmdd%
:: this is Regional settings dependant so tweak this according your current settings
for /f "tokens=2-4 delims=. " %%D in ('echo %DATE%') do set yyyymmdd=%%F%%E%%D
for /f "tokens=2-4 delims=. " %%D in ('echo %DATE%') do set _yyyymmdd=%%F.%%E.%%D
::DEBUG ECHO yyyymmdd IS %yyyymmdd%
:: DEBUG PAUSE


set NICETIME=%yyyymmdd%_%hhmmsss%
set _NICETIME=%_yyyymmdd% - %_hhmmsss%

:: DEBUG PAUSE
echo THE NICETIME IS %NICETIME%
echo THE _NICETIME IS %_NICETIME%
:: DEBUG PAUSE

:: =========END FILE GetNiceTime.cmd ====================================================

Bill Gates on market failures

how-to enable xp_cmdshell_proxy_account on windows server

USE master 

GO

--Step-1: Execute the following query from sql management Studio login as sa.

-- Create a user that will be used for running xp_cmdshell called cmdshelluser

CREATE LOGIN cmdshelluser WITH PASSWORD='pass'

-- Add a Windows domain account Domain\User as the SQL Agent Proxy account

-- where secrtePass is the actual set up password for this windows OS user

EXEC sp_xp_cmdshell_proxy_account 'hostName\username', 'secretPas';

-- Grant database access to the SQL Server login account that you want to provide access.

EXEC sp_grantdbaccess 'cmdshelluser'

-- Grant execute permission on xp_cmdshell to the SQL Server login account. 

GRANT exec ON sys.xp_cmdshell TO cmdshelluser 

GO

--Step-2: Verify that the account is created.

-- To confirm that the ##xp_cmdshell_proxy_account## credential has been created.

select * from sys.credentials

--Step-3: Test executing the xp_cmdshell sp.

EXECUTE AS login = 'cmdshelluser'

-- Execution of xp_cmdshell is allowed.

--And executes successfully!!!

EXEC xp_cmdshell 'DIR C:\*.*'

Solaris Cheat sheet

echo Solaris Cheat Sheet
echo this Cheat Sheet contains quick copy paste stuff for Sun's Solaris OS
echo caveat ... some of the stuff has been copied from my Linux Cheat Sheet
echo and you know Linux is not Unix ; )

echo the time now is `date +%Y.%m.%d-%H:%M:%S`
id
uname -a

echo record the current session via script
script -a /export/home/username/SCRIPTSLOGS/`date +%Y%m%d%H%M%S`_script.log


echo /usr/bin is for normal user executables, /usr/sbin is for superuser executables, /usr/sfw is for external software (like gnu one), but provided with bundle of OS, /usr/ccs is for development utilities, usually not need for daily tasks like make, lex, yacc, sccs




echo where I have been lately ?
history | grep cd

echo take the last 5 commands for faster execution to the temp execution script

tail -n 5 /root/.bash_history >> /var/run.sh

echo I saw the command cd /to/some/suching/dir/which/was/very/long/to/type
so I redid it and saved my fingers
!345

history >history.txt ---- echo the last 1000 commands into a history.txt file

echo send that file to myself

cat history.txt | mail -s "test file sending" -c mail1@com
yordan.georgiev(boom)gmail.com

echo remove all trealing spaces from the history file works for TextPad

^([ ]*)([0-9]*)(.*)$

\3 --- replace with the pure commands

history | gawk -F1 'BEGIN {FS=" "};{print $2 , $3}' | less

echo display the history withouth the line numbers ...

history | perl -i -pe 's/^([ ]*)([0-9]*)(.*)$/$3/gi'





vi fileName anotherFile

echo how to deal with command outputs
command | filtercommand > command_output.txt 2>errors_from_command.txt

echo Hint after the less filter pressing s will prompt you for saving the
output to a file ...

echo find all files and folders containing the word toFind and pipe it to the less for easier viewing
find / -name "*toFind*" 2>/dev/null | less



echo find the files having os somewhere in their names and only those having linux
find . -name '*os*' | grep linux | less

echo find all xml type of files and display only the rows having wordToFindInRow
find . -name '*.xml' -exec cat {} \;| grep wordToFindInRow | less

echo The ultimate "find in files"
find / -name '*bash*' -exec grep -nH tty {} \;

echo or even faster , be aware of "funny file names xargs -0
find / -name '*bak' | xargs grep -nH tty

echo find and replace recursively
find . -name '*.html' -print0 | xargs -0 perl -pi -e 's/foo/bar/g'

echo putty , bash shortcuts
Ctrl + A --- Go to the beginning of the line you are currently typing on
Ctrl + E --- Go to the end of the line you are currently typing on

echo how-to mount an usb stick
echo remember to change the path other wise you will get the device is busy errror

mkdir /mnt/usbflash
mount /dev/sdb1 -t vfat /mnt/usbflash

umount /mnt/usbflash



head -n 20 tooLongFile -- display the first 20 lines of the file

echo change the uggly prompt

vi /etc/bashrc

echo get a nice prompt
PS1="\u@\h \t \w\n\\$ "

echo how to restart a process initiated at startup
/etc/rc.d/init.d/sendmail start | stop | status | restart

echo see all the rules associated with the firewall

iptables -L -v

gunzip *file.zip

echo decompress a tar achive
tar -xvf file.tar

echo zip all my txt files in the current directory into the zipArchiveName file
for file in *.txt
do zip zipArchiveName $file
done ;


To access the server download winscp.exe:

echo start winscp with a stored session from Win box
cmd /c start /max winscp oracle@192.168.255.12

echo To start remote session click on the putty screen , configure putty
settings to pull full screen with alt + Enter

echo right click on the title bar , settings , change the font , copy
paste from and to the terminal window text

echo how to ensure the sshd daemon is running

ps -ef | grep sshd


echo User and group management
echo add user with specifig home directory name and pass
useradd -p winscppass -r winscp -d /home/winscp --- to add a user with
useradd -u 1022215 -c "Yordan Georgiev, , yordan.georgiev@company.com" -m -d /export/home/username -s /bin/bash username



luserdel winscp --- delete the user

gpasswd: administer the /etc/group file
groupadd: Create a new group
groupmod: Modify a group
groupdel: Delete a new group

useradd: Create a new user or update default new user information
usermod: Modify a user account
userdel: Delete a user account and related files


echo how to kill process interactively

killall -v -i sshd

echo disk usage of users under the /home directory

du --max-depth=1 /home | sort -n -r



echo the most efficent way to search your history is to hit Ctrl R and
type the start of the command. It will autocomplete as soon as there’s
a match to a history entry, then you just hit enter. If you want to
complete the command (add more stuff to it ) use the right arrow to
escape from the quick search box ...

How to install Perl modules

gzip -dc yourmodule.tar.gz | tar -xof -

perl Makefile.PL

make test

make install

How to see better which file were opened , which directories were visited

type always the fullpath after the vi - use the $PWD env variable to
open files in the current directory , thus after opening the file
after:

vi /$PWD , press tab to complete the name of the current directory ,
type the name of the file

thus after

history | grep vi



the full list of opened files is viwed .

of course the same could be seen from the /home/username/.viinfo file /files

where to set the colors for the terminal (if you are lucky to have one
with colors; )

/etc/DIR_COLORS

open a file containing "sh" in its name bellow the "/usr/lib" directory

:r !find /usr/lib -name *sh*

go over the file and gf

uname -a --- which version of Linux I am using

rmp -qa --- show all installed packages

passwd [username] --- change the password for the specified user (own password)



How to copy paste text in the putty window from client to server -
click the right button of your pointing device

How to copy paste text from the putty window from server to client -
right-click the window title and select copy all to Clipboard.

To restart a service

service sshd restart

service --status-all --- show the status of all services

chown -R root:nortel Directory

echo perform action recursively on a set of files

find . -name '*.pl' -exec perl -wc {} \;

$ for file in *
> do cp $file $file.bak
> done

$ for file in `ls -R` ; do cp $file $file.bak; done


echo make Bash append rather than overwrite the history on disk:
shopt -s histappend

echo henever displaying the prompt, write the previous line to disk:
PROMPT_COMMAND='history -a'



gpm -- general "cut and paste" server

sh ScriptWithALotOfErrorMessages.sh | tee -a whereToSaveIt.log

echo run first the following command

$ script -a The_Log_File_To_Append_as_well_as_display_diagnostig_messages.log

echo than run the script

sh ScriptWithALotOfErrorMessages.sh

tr '\t' ',' < FileWithTabs > fileWithCommas

df -k --- disk usage

echo Allow access to the box from only one ip address

IPTables=/sbin/iptables
$ IPTables -A INPUT -s -p tcp
--source-port xxx -j ACCEPT
$ IPTables -A OUTPUT -d < Insert other Origin ip here > -p tcp
--destination-port xxx-j ACCEPT

echo has the root logged in over an unencrypted network ?

echo last | grep “^root “ | egrep –v “reboot|console” | more

echo start command in the background
command1 &

echo start another one
command2 &

echo bring the first command in the foreground
fg %1

echo create a backup file based on the timestamp on bash

cp fileName.ext fileName.ext.`date +%Y%m%d%H%M%S`.bak


echo which box I am workign currently
uname -a
echo who am I on this machine
id
echo the current time is( in yyyy.mm.dd HH:MM:SS format )
echo `date +%Y.%m.%d.%H.%M.%S`


find /opt/npm/sfw/oracle/EPM/11.1.1.3 -name "*assembly.dat" | cut -d/ -f9 | sort -u

echo get my IP address
/sbin/ifconfig -a | less

telnet -e "^g" 10.176.246.138 1025
telnet -e "^g" xldb-prod 1025

echo which process the username user is runnig and sort by process name
ps -fu username | sort +7

echo check whether host in DNS
nslookup hostName

echo show the ports which username user is using
/usr/local/bin/show-ports -u username

echo port forwarding with ssh from one host to another via ssh
ssh -L1423:hostName1:1423 hostName2

echo how-to setup port forwarding on Unix
ssh -L22:localhost:22 hostToForwardTo.domain.com

echo scp copy from local to remote host a file
scp ~/doc/SolarisCheatSheet.txt userName@hostName.domain.com:/path/OnHostName/ToCopyTo

Разрешение на енергиините проблеми в България

Фактите:

• България е почти 100% зависима от Русия, която ни продава въглеводороди на по-високи цени отколкото на западните страни и се меси чрез енергията във вътрешната политика на страната ни.

• България е малък енергиен пазар и няма ресурсите да развива собствени технологии за енергиино производство.

• Новите технологии за съхранение на електроенергия ще отстранят двигателите с вътрешно горене с електродвигатели за следващите 10 години.

• Западна Европа и САЩ имат политически интерес България да не бъде под пълното енергиино влияние на Русия (иначе нямаше да ни допуснат в НАТО и ЕС)
•  

Разрешения

• Постепенно вдигане на бюджета на образователното министерство всяка година с 0.5 % от БВП 
•  Промяна на обучението на учащите се - въвеждане на обща програма за заетост и обучение - т.е. учащите се трябва да могат да се самоиздържат работейки по специалността но повишавайки кфалификацията си ...
• Даване на специални преференции на американските компании произвеждащи малки модулни ядрени реактори ... Hyperion etc. 
•  

Install_CAS_TEST

:: START CMD FILE Deploy_DbName.cmd
:: DOCS AT THE EOF FILE

@ECHO OFF
ECHO BEFORE PROCEEDING WITH DEPLOYMENT DID YOU ENSURE
ECHO THAT YOU CHANGE THE CONFIGURATION ENTRIES IN THIS
ECHO CMD FILE IF NOT PRESS CTRL + C AND EDIT THE FILE
ECHO IF YES PRESS A KEY TO CONTINUE
PAUSE



::CHANGE HERE THE APPROPRIATE VARIABLES
SET DbName=CAS_TEST

ECHO SET THE DB FILES WILL BE SITUATED NOT THE \A AT THE END !!!
SET DataPath=D:\cas\Sql_test\DATA\
ECHO DataPath var is %DataPath%


:: CREATE THE DataPath DIRECTORY IF WE DO NOT HAVE IT
MKDIR %DataPath%


ECHO DELETE THE MDF AND LDF FILES IF THEY EXIST
DEL /Q %DataPath%%DbName%.mdf
DEL /Q %DataPath%%DbName%.ldf

::CHANGE HERE THE APPROPRIATE VARIABLES
SET CurrentDate=%Date%

::the Configuration entry of the
SET DbBackupsDirectory=D:\cas\Sql_test\DATA\Backups\

:: CREATE THE DbBackupsDirectory DIRECTORY IF WE DO NOT HAVE IT
MKDIR %DbBackupsDirectory%



ECHO CREATE FIRST BACKUP OF ALL DATABASES ON THE DEFAULT INSTANCE ONES:
ECHO CREATING THE LOG FILES

echo THIS IS THE ERROR LOG OF THE UPDATE OF THE %DbName% ON %DATE% >error.log
echo THIS IS THE INSTALL LOG OF THE UPDATE OF THE %DbName% ON %DATE% >install.log


ECHO STARTTING BACKUP
CD .\0.BackUp
ECHO FOR EACH SQL FILE DO RUN IT THIS WILL TAKE A WHILE
ECHO SINCE WE ARE GOING TO MAKE A BACKUP FOR ALL THE DATABASES ON THE CURRENT HOST

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d MASTER -t 30000 -w 80 -u -p 1 -b -i %%i -r1 1>> "..\install.log" 2>> "..\error.log"

::PAUSE

ECHO GO ONE FOLDER UP

ECHO SLEEP FOR 1 SECOND
ping -n 1 127.0.0.1 >NUL
ECHO DONE WITH BACKUP GOING UP
cd ..

ECHO THE BACKUPS ARE IN THE FOLDER
ECHO %DbBackupsDirectory%
ECHO CLICK A KEY TO CONTINUE
ECHO ========================================================================================================================
::PAUSE






ECHO STARTING INSTALLING FUNCTIONS
CD ".\1.Functions"
ECHO FOR EACH SQL FILE DO RUN IT
ping -n 1 127.0.0.1 >NUL

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log"

ECHO DONE WITH STORED PROCEDDURES GOING UP
cd ..
ping -n 1 127.0.0.1 >NUL

ECHO HIT A KEY AFTER PAUSE
PAUSE




ECHO START TO EXECUTE THE MIXED FILES
CD .\1.Mixed
ECHO CREATING THE LOG FILES
echo. >>"..\error.log"
echo. >>"..\install.log"
ECHO FOR EACH SQL FILE DO RUN IT

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i %%i -r1 1>> "..\install.log" 2>> "..\error.log"

ECHO GO ONE FOLDER UP
cd ..

ECHO SLEEP FOR 1 SECOND
ping -n 1 127.0.0.1 >NUL
ECHO DONE WITH MIXED GOING UP

ECHO HIT A KEY AFTER PAUSE
PAUSE
ECHO STARTING INSTALLING TABLES
CD .\2.Tables
ECHO FOR EACH SQL FILE DO RUN IT
ping -n 1 127.0.0.1 >NUL

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log"


ping -n 1 127.0.0.1 >NUL
ECHO DONE WITH TAbles GOING UP
cd ..
ping -n 1 127.0.0.1 >NUL

ECHO HIT A KEY AFTER PAUSE
PAUSE

ECHO STARTING INSTALLING Views
CD ".\3.Views"
ECHO FOR EACH SQL FILE DO RUN IT
ping -n 1 127.0.0.1 >NUL

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log"

ECHO DONE WITH Views GOING UP
cd ..
ping -n 1 127.0.0.1 >NUL

ECHO HIT A KEY AFTER PAUSE
PAUSE



ECHO STARTING INSTALLING stored procedures
CD ".\5.StoredProcedures"
ECHO FOR EACH SQL FILE DO RUN IT
ping -n 1 127.0.0.1 >NUL

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log"

ECHO DONE WITH STORED PROCEDDURES GOING UP
cd ..
ping -n 1 127.0.0.1 >NUL

ECHO HIT A KEY AFTER PAUSE
PAUSE

ECHO STARTING INSTALLING Triggers
CD ".\6.Triggers"
ECHO FOR EACH SQL FILE DO RUN IT
ping -n 1 127.0.0.1 >NUL

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log"

ping -n 1 127.0.0.1 >NUL
ECHO DONE WITH Triggers GOING UP
cd ..

ping -n 1 127.0.0.1 >NUL

ECHO HIT A KEY AFTER PAUSE
PAUSE


ECHO Please , Review the log files and sent them back to Advanced Application Support


set mailadd= yordan.georgiev^@oxit.fi

:: WE USE THE "%cd%\bin\bmail.exe".EXE UTILITY TO SEND OURSELF AN E-MAIL CONTAINING THE TEXT FILE
:: ALTERNATIVE SMTP MIGHT BE esebe107.NOE.Nokia.com, UNCOMMENT THE NEXT LINE FOR ALTERN
::cmd /c "%cd%\bin\bmail.exe" -s esebe107.NOE.Nokia.com -m %computername%.txt -t %mailadd% -a %computername% -h
::"%cd%\bin\bmail.exe" -s smtp.nokia.com -m install.log -t yordan.georgiev@oxit.fi -a "POC 1.2 install log" -h

::"%cd%\bin\bmail.exe" -s smtp.nokia.com -m error.log -t yordan.georgiev@oxit.fi -a "POC 1.2 error log" -h





cmd /c start /max INSTALL.LOG
CMD /C start /MAX ERROR.LOG
echo DONE !!!
ECHO HIT A KEY TO EXIT
PAUSE


:: WE GO TROUGH ALL THE FOLDERS AND RUN THE SQL FILES IN ALPHABETIC ORDER

Install_CAS_DEV

:: START CMD FILE Deploy_DbName.cmd
:: DOCS AT THE EOF FILE

@ECHO OFF
ECHO BEFORE PROCEEDING WITH DEPLOYMENT DID YOU ENSURE
ECHO THAT YOU CHANGE THE CONFIGURATION ENTRIES IN THIS
ECHO CMD FILE IF NOT PRESS CTRL + C AND EDIT THE FILE
ECHO IF YES PRESS A KEY TO CONTINUE
::PAUSE



::CHANGE HERE THE APPROPRIATE VARIABLES
SET DbName=CAS_DEV

::THIS IS WHERE THE DB FILES WILL BE SITUATED NOT THE \A AT THE END !!!
SET DataPath=D:\cas\DATA\

:: CREATE THE DataPath DIRECTORY IF WE DO NOT HAVE IT
MKDIR %DataPath%

ECHO DELETE THE MDF AND LDF FILES FROM THE DATA DIRECTORY OF THE EXISTING DATABASE
DEL /Q %DataPath%%DbName%.mdf
DEL /Q %DataPath%%DbName%.ldf

::DEBUG PAUSE

::CHANGE HERE THE APPROPRIATE VARIABLES
SET CurrentDate=%Date%

::the Configuration entry of the
SET DbBackupsDirectory=D:\cas\Data\DbBackups\

:: CREATE THE DbBackupsDirectory DIRECTORY IF WE DO NOT HAVE IT
MKDIR %DbBackupsDirectory%



ECHO CREATE FIRST BACKUP OF ALL DATABASES ON THE DEFAULT INSTANCE ONES:
ECHO CREATING THE LOG FILES

echo THIS IS THE ERROR LOG OF THE UPDATE OF THE %DbName% ON %DATE% >error.log
echo THIS IS THE INSTALL LOG OF THE UPDATE OF THE %DbName% ON %DATE% >install.log


ECHO STARTTING BACKUP
CD .\0.BackUp
ECHO FOR EACH SQL FILE DO RUN IT THIS WILL TAKE A WHILE
ECHO SINCE WE ARE GOING TO MAKE A BACKUP FOR ALL THE DATABASES ON THE CURRENT HOST

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d MASTER -t 30000 -w 80 -u -p 1 -b -i %%i -r1 1>> "..\install.log" 2>> "..\error.log"

::::PAUSE

ECHO GO ONE FOLDER UP

ECHO SLEEP FOR 1 SECOND
ping -n 1 127.0.0.1 >NUL
ECHO DONE WITH BACKUP GOING UP
cd ..

ECHO THE BACKUPS ARE IN THE FOLDER
ECHO %DbBackupsDirectory%
ECHO CLICK A KEY TO CONTINUE
ECHO ========================================================================================================================
::::PAUSE






ECHO STARTING INSTALLING FUNCTIONS
CD ".\1.Functions"
ECHO FOR EACH SQL FILE DO RUN IT
ping -n 1 127.0.0.1 >NUL

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log"

ECHO DONE WITH STORED PROCEDDURES GOING UP
cd ..
ping -n 1 127.0.0.1 >NUL

ECHO HIT A KEY AFTER ::PAUSE
::PAUSE




ECHO START TO EXECUTE THE MIXED FILES
CD .\1.Mixed
ECHO CREATING THE LOG FILES
echo. >>"..\error.log"
echo. >>"..\install.log"
ECHO FOR EACH SQL FILE DO RUN IT

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i %%i -r1 1>> "..\install.log" 2>> "..\error.log"

ECHO GO ONE FOLDER UP
cd ..

ECHO SLEEP FOR 1 SECOND
ping -n 1 127.0.0.1 >NUL
ECHO DONE WITH MIXED GOING UP

ECHO HIT A KEY AFTER ::PAUSE
::PAUSE
ECHO STARTING INSTALLING TABLES
CD .\2.Tables
ECHO FOR EACH SQL FILE DO RUN IT
ping -n 1 127.0.0.1 >NUL

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log"


ping -n 1 127.0.0.1 >NUL
ECHO DONE WITH TAbles GOING UP
cd ..
ping -n 1 127.0.0.1 >NUL

ECHO HIT A KEY AFTER ::PAUSE
::PAUSE

ECHO STARTING INSTALLING Views
CD ".\3.Views"
ECHO FOR EACH SQL FILE DO RUN IT
ping -n 1 127.0.0.1 >NUL

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log"

ECHO DONE WITH Views GOING UP
cd ..
ping -n 1 127.0.0.1 >NUL

ECHO HIT A KEY AFTER ::PAUSE
::PAUSE



ECHO STARTING INSTALLING stored procedures
CD ".\5.StoredProcedures"
ECHO FOR EACH SQL FILE DO RUN IT
ping -n 1 127.0.0.1 >NUL

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log"

ECHO DONE WITH STORED PROCEDDURES GOING UP
cd ..
ping -n 1 127.0.0.1 >NUL

ECHO HIT A KEY AFTER ::PAUSE
::PAUSE

ECHO STARTING INSTALLING Triggers
CD ".\6.Triggers"
ECHO FOR EACH SQL FILE DO RUN IT
ping -n 1 127.0.0.1 >NUL

for /f %%i in ('dir *.SQL /s /b /o') DO ECHO %DATE% --- %TIME% RUNNING %%i 1>>"..\install.log"&SQLCMD -U ysg -P pass -S hostName\POC_QA -d %DbName% -t 3000 -w 80 -u -p 1 -b -i "%%i" -r1 1>> "..\install.log" 2>> "..\error.log"

ping -n 1 127.0.0.1 >NUL
ECHO DONE WITH Triggers GOING UP
cd ..

ping -n 1 127.0.0.1 >NUL

ECHO HIT A KEY AFTER ::PAUSE
::PAUSE


ECHO Please , Review the log files and sent them back to Advanced Application Support


set mailadd= yordan.georgiev^@oxit.fi

:: WE USE THE "%cd%\bin\bmail.exe".EXE UTILITY TO SEND OURSELF AN E-MAIL CONTAINING THE TEXT FILE
:: ALTERNATIVE SMTP MIGHT BE esebe107.NOE.Nokia.com, UNCOMMENT THE NEXT LINE FOR ALTERN
::cmd /c "%cd%\bin\bmail.exe" -s esebe107.NOE.Nokia.com -m %computername%.txt -t %mailadd% -a %computername% -h
::"%cd%\bin\bmail.exe" -s smtp.nokia.com -m install.log -t yordan.georgiev@oxit.fi -a "POC 1.2 install log" -h

::"%cd%\bin\bmail.exe" -s smtp.nokia.com -m error.log -t yordan.georgiev@oxit.fi -a "POC 1.2 error log" -h





cmd /c start /max INSTALL.LOG
CMD /C start /MAX ERROR.LOG
echo DONE !!!
ECHO HIT A KEY TO EXIT
::PAUSE


:: WE GO TROUGH ALL THE FOLDERS AND RUN THE SQL FILES IN ALPHABETIC ORDER

How google blogger post deals with *.ext file globbing

Well it makes for each file a post !!!
google blogger post *.txt

google blogger post title="Some root history" ~/.bash_history

ha ha ha a security breach :
google blogger post title="Some root history" ~/.bash_history


python -v
python -V
python -v
exit
clear
deb http://deb.opera.com/opera/ stable non-free
wget -O - http://deb.opera.com/archive.key | sudo apt-key add -
deb http://deb.opera.com/opera/ stable non-free
apt-get update
apt-get install opera non-free
apt-get install opera
apt-get install flashplugin non-free
sudo apt-get install flashplugin-nonfree
clear
apt-get install vlc
clear
uname -a
vi LinuxCheatSheet.txt
less LinuxCheatSheet.txt
set
set echo PORTABLE *NIX CHEAT SHEET COPY PASTE AT YOUR COMMAND PROMPT
echo AND USE BY history | grep "a word"
echo how-to script --- script -a /export/home/yogeorgi/SCRIPTSLOGS/`date +%Y%m%d%H%M%S`_script.log
echo if the man is full of references to files --- man commandToFindHelpAbout | col -b >/var/man/mancommandToFindHelpAbout.man.txt
vim .bashrc
echo´'
alias ls="ls -a -l -X -1 --color=tty"
alias dir="ls -ba"
alias cls="clear"
alias deltree="rm -r"
alias move="mv"
ls -al | more
'
echo take the last 5 commands for faster execution to the temp execution script --- tail -n 5 /root/.bash_history >> /var/run.sh
echo I saw the command cd /to/some/suching/dir/which/was/very/long/to/type so I redid it and saved my fingers --- '!345'
echo send that file to myself --- cat history.txt | mail -s "test file sending" -c mail1@com yordan.georgiev(boom)gmail.com
echo how-to display the history withouth the line numbers ... --- history | perl -i -pe 's/^([ ]*)([0-9]*)(.*)$/$3/gi'
echo how-to deal with command outputs --- command | filtercommand > command_output.txt 2>errors_from_command.txt
echo find the files in the /bin folder having the "trace" string in their name --- find /bin | grep "trace"
echo find all xml type of files and display only the rows having wordToFindInRow --- find . -name '*.xml' -exec cat {} \;| grep wordToFindInRow | less
set
set | less
clear
pwd
whoami
id
vi /etc/passwd
apt-get install LAMP
perl -V
l
cldear
clear
sudo aptitude install apache2 php5 apache2.2-common libapache2-mod-auth-mysql php5-mysql mysql-server
sudo vim /etc/apache2/ports.conf
sudo vi /etc/apache2/ports.conf
clear
mkdir ~/SCRIPTSLOGS
script -a ~/SCRIPTSLOGS/`date +%Y%m%d%H%M%S`_script.log
sudo aptitude install php5-gd
sudo /etc/init.d/apache2 restart
sudo /etc/init.d/mysql restart
service mysql restart
clear
ps -ef | grep mysql
ps -ef | grep apache
service apache2 restart
sudo aptitude install phpmyadmin
ls -al
clear
vi /etc/apt/sources.list
sudo apt-get udpate
sudo apt-get update
clear
sudo apt-get install chromium-browser
gedit
history | script
history | grep script
script -a ~/SCRIPTSLOGS/`date +%Y%m%d%H%M%S`_script.log
sudo script -a ~/SCRIPTSLOGS/`date +%Y%m%d%H%M%S`_script.log
ls- al /home/userName
ls -al /home/userName
ls -al /home
chown -R username:username /home/userName
sudo chown -R username:username /home/userName
sudo chown -R username:username /home/username
id
hostname -i
history | sed 's/\s*[0-9]*\s*//'
history | less
cal
strace -c ls >/dev/null
top
ps -e -orss=,args= | sort -b -k1,1n | pr -TW$COLUMNS
ps -e -orss=,args= | sort -a -k1,1n | pr -TW$COLUMNS
sort --help
sort --help | less
ps -e -orss=,args= | sort -b -r -k1,1n | pr -TW$COLUMNS
clear
tcpdump not port 22
ip link show
df -k
history | grep chro
history | grep apt
halt
sudo apt-get install skype
sudo apt-get install skype non-free
sudo apt-get update && sudo apt-get install skype
skype
clear
halt
sudo halt
vi /etc/apt/sources.list
sudo apt-get update
sudo aptitude install oracle-xe oracle-xe-client
perl -V
sudo apt-get install python-gdata
sudo dpkg -i http://googlecl.googlecode.com/files/googlecl_0.9.5-1_all.d
sudo dpkg -i http://googlecl.googlecode.com/files/googlecl_0.9.8_all.d
sudo dpkg -i http://googlecl.googlecode.com/files/googlecl_0.9.
sudo apt-get install python-gdata
sudo dpkg -i http://googlecl.googlecode.com/files/googlecl_0.9.5-1_all.deb
sudo dpkg -i http://googlecl.googlecode.com/files/*
sudo dpkg -i /home/username/Documents/A_DOWNLOADS/GOOGLE/googlec
sudo dpkg -i /home/username/Documents/A_DOWNLOADS/GOOGLE/googlec/
ls -al /home/username/Documents/A_DOWNLOADS/GOOGLE/googlec/
ls -al /home/username/Documents/A_DOWNLOADS/GOOGLE/
cd /home/username/Documents/A_DOWNLOADS/GOOGLE/googlec/
cd /home/username/Documents/A_DOWNLOADS/GOOGLE/
googlecl picasa list
google calendar add "todo"
googlecl calendar add "todo"
googlecl
python googlecl
sudo dpkg -i /home/username/Documents/A_DOWNLOADS/GOOGLE/googlecl/googlecl_0.9.8-1_all.deb
cd ~/
ls -al
clear
cd Pictures/
google picasa list
cal
time
gettime
utc
time
clear
google picasa list
exit
google picasa list title,url-direct --query "A tag"
exit
wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -
clear
history | grep vi
vi /etc/apt/sources.list
sudo apt-get update
sudo apt-get install sun-java5-bin
sudo apt-get install sun-java6-bin
sudo /etc/init.d/oracle-xe configure
google docs list title,url-direct --delimiter ": " # list docs
clear
google docs list title,url-direct --delimiter ": " # list docs
google picasa list title,url-direct --query "A tag"
google picasa list title,url-direct
google
google --help
google --help | less
google picasa list
history
clear
history
exit
sudo wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -
sudo bash
exit
sudo bash
cd /home/username/Pictures/
google picasa list title,url-direct --query "A tag"
sudo google picasa list title,url-direct --query "A tag"
sudo bash
id
history
9,999
clear
exit
history | grep apt
history | grep apt| sed s/\s+[0-9]*//
history | grep apt| sed s/^\s+[0-9]*//
history
less /home/username/.bash_history
ls -al /home/username/Pictures/
ls -al /home/username/Pictures/ | less
apt-get install picasa
apt-get install picasa non-free
google --help | less
history
google picasa list
clear
google blogger post ~/bash_history --title history
google blogger post ~/.bash_history --title history
less command_output.txt
google picasa list url-direct
clear
echo echo all my picasa pics url into a file
google picasa list url-direct > /home/username/Pictures/MyPicasaPics.txt
echo when was the last reboot
last reboot
echo Show amount of (remaining) RAM (-m displays in MB)
free -m
cd /home/username/Pictures/
ls -al
MyPicasaPics.txt .
MyPicasaPics.txt
gedit MyPicasaPics.txt
for ii in ('less MyPicasaPics.txt') do echo $ii ;
for line in $ (cat file.txt) do echo "$ line" done
for line in $(cat file.txt) do echo "$ line" done; ;
for line in $ (cat file.txt) do echo "$ line" done;
for line in $(cat MyPicasaPics.txt) do echo "$line" ; done ;
for line in $(cat MyPicasaPics.txt) do echo "$line" done ; ;
for line in $(cat MyPicasaPics.txt) do e
for line in $(cat MyPicasaPics.txt) do ; echo "$line"
for line in $(cat MyPicasaPics.txt) do ; echo "$line" ; done ;
for line in $(cat MyPicasaPics.txt) do echo "$line" ; done ;
for line in $(cat MyPicasaPics.txt) ; do echo "$line" ; done ;
echo foreach line of file print file line
for line in $(cat MyPicasaPics.txt) ; do echo "$line" ; done ;
clear
echo for each url in my PicasaPics do download with wget from the url
for line in $(cat MyPicasaPics.txt) ; do wget "$line" ; done ;
clear
ls -1R | grep .*.jpg | wc -lå
ls -1R | grep .*.jpg | wc -l
echo how-to count the number of files in directory of a specific type
ls -1R | grep .*.jpg | wc -l
history | google blogger post --title "History"
google blogger post --title "History" ~/.bash_history
reboot
history
sudo bash
history | grep apt | sed 's/\s*[0-9]*\s*//'
history | grep apt | sed 's/\s*[0-9]*\s*//' > /home/username/Documents/GrepApt.txt
google blogger post /home/username/Documents/GrepApt.txt
sudo google blogger post /home/username/Documents/GrepApt.txt
sudo bash
halt
sudo halt
exit
apt-get install vim-gnome
vim SedCheatSheet.txt
google blogger post --title "Sed Cheat Sheet (revised )" ~/Documents/SedCheatSheet.txt
clear
sqlplus
history | grep date
echo %Y%m%d_%H%M%S
echo %Y%m%d%_H%M%S
echo `date %Y%m%d%_H%M%S`
echo 'date %Y%m%d%_H%M%S'
echo `date %Y%m%d%_H%M%S`
echo `date +%Y%m%d%_H%M%S`
echo `date +%Y%m%d_%H%M%S`
sudo gedit ~/.config/chromium/Default/Preferences
exit
cd Documents/
ls -al
vim SedCheatSheet.txt
sudo bash
exit
history
history | grep apt
apt-get update all
apt-get update
vi /etc/apt/sources.list
google blogger post --title "Ubuntu apt-get sources config " /etc/apt/sources.list
clear
vi /etc/apt/sources.list
clear
echo `date +%Y%m%d%H%M%S`.bak
echo
echo GetNiceTime nice time `date +%Y%m%d_%H%M%S`
apt-get install sqlplus
find / -name "*oracle*" | less
halt
sudo bash
find / -name "demo/schema/human_resources
find / -name "*demo/schema/human_resources*" 2> /dev/null | less
find / -name "*demo/schema/human_resources*" | less 2> /dev/null
find / -name "*oracle*" | less 2> /dev/null
find / -name "*schema*" | less 2> /dev/null
cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/demo/schema
ls -al
vi human_resources/
./human_resources/
cd human_resources/
ls -al
sqlplus
set
set | less
pushd
push
history | grep cd
pwd
cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/demo/schema/human_resources
vi /home/username/.profile
find / -name "*sqlplus" | less
vi /home/username/.profile
find / -name "*sqlplus" | less
vi /home/username/.profile
exit
sudo bash
exit
set | grep '/bin/'
set | less
history | grep vi
vi /home/username/.profile
vi /home/username/.bashrc
exit
set | less
sudo bash
export PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/client/bin/
echo $PATH
sqlplus
clear
pwd
mkdir scripts
cd scripts/
cd
pwd
cd scripts/
mkdir ora_sh
cd ora_sh/
vi test.sh
ls -al
chmod 755 test.sh
ls -al
./test.sh
vi test.sh
./test.sh
history | tail
history
vi test.sh
cd /home/username/scripts/ora_sh/
clear
./test.sh
vi test.sh
./test.sh
halt
sudo halt
vi
clear
ls -al
exit
apt-get istall eclipse
apt-get install eclipse
eclipse
exit
cd /home/username/Downloads/PadWalker-1.92/
ls -al
perl Makefile.PL
make
make test
make install
clear
history | less
sudo apt-get install compiz compizconfig-settings-manager
clear
ls -al
history
halt
eclipse
apt-get install eclipse
sudo bash
id
clear
cd /home/username/workspace/
ls -al
cd FirstPerlProject
ls -al
eclipse .projecte
eclipse .project
perl
perl -e 'ppm install PadWalker'
stall PadWalker'
sudo bash
ifconfig /all
ifconfig
clear
ifconfig | less
apt-get install qt
apt-get install libqt3
cd /home/username/Documents/A_DOWNLOADS/Perl/
ls -al
tar zxvf Komodo-Edit-5.2.4-4343-linux-libcpp6-x86_64.tar.gz
cd Komodo-Edit-5.2.4-4343-linux-libcpp6-x86_64/
sh install.sh
vi install.sh
./install.sh
vi install.
vim install.sh
./install.sh -h
./install.sh
vi install.sh
top
exig
exit
cd /home/username/Documents/A_DOWNLOADS/Perl
pwd
tar xgzv Komodo-Edit-6.0.0-beta2-5550-linux-libcpp6-x86.tar.gz
tar -xgzv Komodo-Edit-6.0.0-beta2-5550-linux-libcpp6-x86.tar.gz
tar zxvf Komodo-Edit-6.0.0-beta2-5550-linux-libcpp6-x86.tar.gz
cd Komodo-Edit-6.0.0-beta2-5550-linux-libcpp6-x86/
./install.sh
vi /home/username/.bashrc
export PATH="/home/username/Komodo-Edit-6/bin:$PATH"
komodo
exit
chown -R username:username
chown -R username:usename *
chown -R username *
ls -al
rm -Rf Komodo-Edit-6.0.0-beta2-5550-linux-libcpp6-x86
ls -al
exit
cd /opt/procs/perl/
clear
perl -wc FirstModule.pm
cd /root
mkdir A_DOWNLOADS
mv Komodo-IDE-5.2.4-37659-linux-libcpp6-x86.tar.gz A_DOWNLOADS/
cd A_DOWNLOADS/
ls -al
mkdir Perl
mv Komodo-IDE-5.2.4-37659-linux-libcpp6-x86.tar.gz Perl/
cd Perl/
cd P
clear
tar -xvfz Komodo-IDE-5.2.4-37659-linux-libcpp6-x86.tar.gz
tar xvfz Komodo-IDE-5.2.4-37659-linux-libcpp6-x86.tar.gz
cd Komodo-IDE-5.2.4-37659-linux-libcpp6-x86/
./install.sh
vi /home/username/.bashrc
komodo
cd /home/username/Komodo-IDE-5/bin
ls -al
komodo
cd komodo
komodo
exit
tar zxvf
cd /home/username/Documents/A_DOWNLOADS/Perl/
rm *
rmdir Komodo-Edit-5.2.4-4343-linux-libcpp6-x86_64/
rmdir -f Komodo-Edit-5.2.4-4343-linux-libcpp6-x86_64/
rmdir --help
rm --help
rm -rf *
sudo rm -rf *
ls -al
clear
echo wpd
echo `pwd`
sudo bash
id
vi ~./bashrc
vi /home/username/.bashrc
komodo
vi /home/username/.bashrc
clear
ls -al
tar xfvz Komodo-Edit-6.0.0-beta2-5550-linux-libcpp6-x86
tar xfvz Komodo-Edit-6.0.0-beta2-5550-linux-libcpp6-x86.tar.gz
cd Komodo-Edit-6.0.0-beta2-5550-linux-libcpp6-x86/
./install.sh
cd ..
ls -al
sudo bash
clear
tar xzvf Komodo-Edit-6.0.0-beta2-5550-linux-libcpp6-x86.tar.gz
cd Komodo-Edit-6.0.0-beta2-5550-linux-libcpp6-x86/
./install.sh
/home/username/Komodo-Edit-6/bin/komodo
chown -R username /home/username/Komodo-Edit-6/
komodo
/home/username/Komodo-Edit-6/bin/komodo
chown -R /home/username/.komodoedit/
chown -R username /home/username/.komodoedit/
/home/username/Komodo-Edit-6/bin/komodo
sudo /home/username/Komodo-Edit-6/bin/komodo
sudo bash
cd /home/username/Documents/A_DOWNLOADS/Perl/
tar xvfz Komodo-IDE-5.2.4-37659-linux-libcpp6-x86.tar.gz
ls -al
cd Komodo-IDE-5.2.4-37659-linux-libcpp6-x86/
./install.sh
rm -fR /home/username/Komodo-IDE-5/
sudo rm -fR /home/username/Komodo-IDE-5/
./install.sh
komodo
vi ~/.bashrc
cd /home/username/Komodo-IDE-5/bin
ls -al
komodo
ls -al
komodo
exit
halt
komodo
ppm install Text::CSV_XS
perl
perl -e 'ppm install Text::CSV_XS'
perl -e 'ppm install Text::CSV_XS; '
find / -name "*perl*"
find / -name "*perl*" 2>/dev/null
find / -name "*perl*" 2>/dev/null | less
find / -name "*ppm*" 2>/dev/null | less
find / -name "*perl*" 2>/dev/null | less
clear
cpan
sudo bash
apt-get update
apt-get install all
apt-get help
apt-get upgrade help
uname -a
apt-get install opera
apt-get install firefox
apt-get install chromium
ps -ef | less
ps | grep ultra
ps | grep Ultra
ps | grep username
ps -efa
ps --help
ps -efo username
ps -efu
ps -efwu
ps -efw
ps -efw | less
ps -efw | grep usr | less
ps -efw | grep usr | grep username | less
sudo halt
ls / -al
ls /var/log
ls /var/log -al
tail -200 /var/log -al
tail --help
tail --help | less
clear
tail -n 200 /var/log/syslog
tail -n 200 /var/log/syslog | less
clear
tail -n 200 /var/log/syslog.1 | less
grep -r /var/log error
grep -h | less
grep --help | less
grep -r error /var/log
grep -r error /var/log | less
grep -r error /var/log | grep dbus

clear
ls / -al
ls /opt -al
ls /bin -al
ls /bin -al | less
find / -name "*vi*" | less
find / -name "*bin*vi*" | less
man sed
clear
reboot
sudo bash
set
set | less
clear
apt-get install php5-gd
mkdir /home/username/Downloads/Drupal
mv /home/username/Downloads/drupal-7.0-alpha6.tar.gz /home/username/Downloads/Drupal/
cd /home/username/Downloads/Drupal/
clear
ls -al
exit
pwd
cd Downloads/Drupal/
tar xgfz drupal-7.0-alpha6.tar.gz
tar xgzf drupal-7.0-alpha6.tar.gz
tar --help
tar --help | less
tar xvzf drupal-7.0-alpha6.tar.gz
ls -al
sudo chown -Rv username /home/username/Downloads/
cd Drupal/
tar xzfv drupal-7.0-alpha6.tar.gz
find . -name README.txt
halt
sudo halt
ifconfig | less
reboot
sudo bash
sudo bash -
id
set
set | less
clear
ls -al
mkdir tmp
cd tmp/
ls -al
for
for $number in 1 2 3 4 5 do ; echo $number > $number.txt
for $number in 1 2 3 4 5 do ; echo $number > $number.txt ; done
for $number in 1 2 3 4 5 do echo $number > $number.txt ; done
for $number in 1 2 3 4 5 do echo "$number" > "$number".txt ; done
for number in 1 2 3 4 5 do echo "$number" > "$number".txt ; done
for number in 1 2 3 4 5 do ; echo "$number" > "$number".txt ; done
for i in 1 2 3 4 5 do ; echo "$i" > "$i".txt ; done
for i in 1 2 3 4 5 do ; echo "$i" > "$i".txt ; done ;
for i in 1 2 3 4 5 do echo "$i" > "$i".txt ; done ;
for i in 1 2 3 4 5 do echo $i > $i.txt ; done ;
for i in 1 2 3 4 5 do echo $i ; done ;
for i in 1 2 3 4 5 do echo $i done ; for i in 1 2 3 4 5 do echo $i done
for i in 1 2 3 4 5 do ; echo $i done ; for i in 1 2 3 4 5 do echo $i done
for i in 1 2 3 4 5 do ; echo $i done ;
for i in 1 2 3 4 5 do echo $i done ;
for i in 1 2 3 4 5 do echo $i done
for i in 1 2 .. N ; do echo $i; done
for i in 1 2 3 4 5 ; do echo $i; done
for i in 1 2 3 4 5 ; do echo $i >$i.txt ; done
ls -al
vi 1.txt
for file in *.txt echo $file; done ;
for file in *.txt echo $file; done
for file in *.txt ; do echo $file; done
for i in 1 2 3 4 5 ; do echo $i >$i.log ; done
ls -al
for file in *.txt *.log ; do echo $file; done
for file in *.txt *.log ; do cp -fvfor VARIABLE in 1 2 3 4 5 .. N $file; done
do
command1
command2
commandN
cp --help
cp --help | less
clear
for file in *.txt *.log ; do cp -fv $file $file.bak ; done
ls -al
ls -al | sort
ls -al | sort +5
clear
find `pwd` | xargs echo
find `pwd` | xargs cp -v
find `pwd` -exec for VARIABLE in 1 2 3 4 5 .. N

command1
command2
commandN
find `pwd` -exec echo {}
find `pwd` -exec echo {} \;
find `pwd` -exec cp {} '{}'.bak \;
ls -al
find `pwd` -name "*.bak.bak" -exec rm {} \;
ls -al
find `pwd` -name "*.log.bak" -exec rm {} \;
ls -al
find `pwd` -name "*.txt.bak" -exec rm {} \;

find `pwd` -name "*.txt" -exec cp {} '{}'.bak \;
ls -al
history | grep find
clear
apt-get install glipper~
cd /home/username/.opera/temporary_downloads/glipper/
clear
./configure --prefix=/usr --with-gconf-schema-file-dir=/usr/share/gconf/schemas
cd glipper-1.0/
./configure --prefix=/usr --with-gconf-schema-file-dir=/usr/share/gconf/schemas
sudo aptitude install python-dev
./configure --prefix=/usr --with-gconf-schema-file-dir=/usr/share/gconf/schemas
apt-get install gtk+-2.0
apt-get install gtk
apt-get install gtk+
apt-get install gtk+-2.0
apt-get install xclip
xclip
xclip --help
apt-get install glipper
glipper
vi ~./glipper
vi /home/username/.glipper/
cd /home/username/.glipper/
clear
ls -al
vi history
clear
halt
ls -al
mkdir tpm
mkdir tmp
cd tmp
ls -al
for i in *.txt do echo $i done ; ;
for i in *.txt ; do echo $i done ; ;
for i in *.txt do echo $i done ; ;
for i in *.txt; do echo $i done ; ;
for i in *.txt do; echo $i done ; ;
history
ls /boot
find / -name "*menu.lst" 2>/dev/null | less
vi /usr/share/doc/memtest86+/examples/grub-menu.lst
sudo bash -
su -
cd /boot
ls -al
cd grub
ls -al
ls -al me*
cd /etc/grub.d
ls -al
vi README
vi 40_custom
gksu gedit /boot/grub/menu.lst
vi /boot/grub/menu.lst
update-grub
sudo su -
sudo bash
sudo /etc/grub.d/30_os-prober
gedit /etc/grub.d/30_os-prober
vi /etc/grub.d/10_linux
sudo update-grub
find / -name "*grub.cfg" 2>/dev/null | less
vi /boot/grub/grub.cfg
gedit /boot/grub/grub.cfg
grub-install -v
vi /etc/grub.d/00_header
vi /etc/grub.d/10_linux
clear
vi /etc/default/grub
history
update-grub
reboot
exit
su -
sudo bash
sudo su -
clear
uptime

ZipMe.pl - a perl script for making timestamped tars

#!/usr/bin/perl -w
#This script compresses recursively a directory
#into a tar with dir_timestamp name
#where timestamp is in the YYYYMMDD_HHmmSS format
#source: linux forums

$dir_in=shift(@ARGV);
chomp($dir_in);
$dir_in =~ tr/\///d;
print "Archiving $dir_in/* ...\n";
use POSIX qw(strftime);
$now_string = strftime "%Y%m%d_%H%M%S" , localtime;
$tarname=$dir_in."_".$now_string.".tar.gz";
$execstring="tar -zpscf".$tarname." ".$dir_in."/*";
#debug print($execstring); # uncomment to debug
system($execstring);
print("\n"); 

how-to select a default entry for grub 2

- Check that you have the correct grub version :
update-grup -v
- Should be above 0.97
- Edit the default configuration file for grub
vi /etc/default/grub
- Change the following line
GRUB_DEFAULT=0
- to
GRUB_DEFAULT=n

where n is a whole number which is the desired list entry you see in the boot loading menu starting from 0

- Regerate the boot menu with:
update-grub
- Reboot to see the changes
reboot

Find examples on Unix

find `pwd` -name "*.txt" -exec cp {} '{}'.bak \;
find `pwd` -exec echo {} \;
find `pwd` -exec cp {} '{}'.bak \;
find `pwd` -name "*.bak.bak" -exec rm {} \;
find `pwd` -name "*.txt" -exec cp {} '{}'.bak \;