Search This Blog

2008-01-29

creative session logging on Solaris

script -a ~/script/`date +%Y%m%d%H%M%S`.script.log

2008-01-24

Bash shortcuts from PUTTY

Ctlr + A - go to the beginning of line

Ctrl + E - go to the end of line

Ctrl + W - delete a word

Alt + f - Move forward

Alt + B - move backwords

Alt + BackSpace - Delete backward from cursor

down arrow - browser command history backwords

up arrow - browse command history upwards

Ctrl + r - Recall command

Ctrl + z - Suspend/ Stop the command

Search the history backwards

Ctrl + l - clear the screen



Here "2T" means Press TAB twice

$ 2T - All available commands(common)
$ (string)2T - All available commands starting with (string)
$ /2T - Entire directory structure including Hidden one

alternative of net use command on the cmd prompt on Windows

Open a Command Prompt window.
Type the following command line:
PUSHD ServerSharepath

where \\Server\Share\path is the network resource to which you want to map a drive letter.

As soon as you do, the PUSHD command will instantly map a drive letter to the network resource and then change to that drive right in the Command Prompt window. When you’re done, just type POPD and the mapped drive letter will be disconnected and you’ll return to your original drive.

Keep in mind that, the PUSHD command allocates drive letters from Z: on down and will use the first unused drive letter that it finds.
http://blogs.techrepublic.com.com/window-on-windows/?p=594

2008-01-22

test C# publishing

п»ї<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.ADO" %>
<html>
<head>
<script language="C#" runat="server">
{
string strCn = "DSN=pubs";
string strCmd = "Select * From Products";
ADOConnection cn = new ADOConnection(strCn);
ADODataSetCommand cmd = new ADODataSetCommand(strCmd,cn);
DataSet ds = new DataSet();
cmd.FillDataSet(ds, "Products");
ListBox1.DataSource = ds.tables["Products"].DefaultView;
ListBox1.DataBind();
}
</head>
<body>
<form method="post" action="2000081703.aspx" runat="server"
<asp:ListBox id="ListBox1" Runat="server">

<DataTextField="ProductName" DataValueField="ProductID" />
</form>
</body>
</html>

2008-01-21

How to restart Ubuntu network connection manager

sudo /etc/dbus-1/event.d/25NetworkManagerDispatcher restart
sudo /etc/dbus-1/event.d/26NetworkManagerDispatcher restart

Still wandering why my country joined EU

SOURCES:
Donh't be naive - it was about the natural gas !!!

2008-01-10

what was the point of the previous one

well to have the best possible format for your history - html ; )

perl /usr/bin/parseHistoryFile.pl --verbose --html /home/$USER/.mozilla/firefox/8sllsdks.default/history.dat > /var/www/tmp.html

Note - the 8sllsdks.default is something else on your system
and you would have to replace $USER with your user name

parse automatically firefox history file


#!/usr/bin/perl -w
# Copyright © 2004 Jamie Zawinski <jwz@jwz.org>
#
# Permission to use, copy, modify, distribute, and sell this software and its
# documentation for any purpose is hereby granted without fee, provided that
# the above copyright notice appear in all copies and that both that
# copyright notice and this permission notice appear in supporting
# documentation. No representations are made about the suitability of this
# software for any purpose. It is provided "as is" without express or
# implied warranty.
#
# Created: 3-Mar-2004 by Jamie Zawinski, Anonymous, and Jacob Post.
#
##############################################################################
#
# This is a program that can read the Mozilla URL history file --
# normally $HOME/.mozilla/default/*.slt/history.dat -- and prints out
# a list of URLs and their time of last access. With no arguments,
# it prints lines like
#
# 1078333826 1 http://www.jwz.org/hacks/
#
# where the first number is a ctime (number of seconds since Jan 1 1970 GMT)
# and the second number is how many times this URL was visited. The URLs are
# printed most-recent-first.
#
# With -vv, it prints all the information known about each URL,
# including time of first visit, last visit, document title, etc.
#
# With --html, it produces HTML output instead of plain text.
#
# With "--age 2H", it limits itself to URLs that were loaded within the
# last two hours. Likewise with "sec", "min", "day", "month", etc.
#
##############################################################################
#
# And Now, The Ugly Truth Laid Bare:
#
# In Netscape Navigator 1.0 through 4.0, the history.db file was just a
# Berkeley DBM file. You could trivially bind to it from Perl, and
# pull out the URLs and last-access time. In Mozilla, this has been
# replaced with a "Mork" database for which no tools exist.
#
# Let me make it clear that McCusker is a complete barking lunatic.
# This is just about the stupidest file format I've ever seen.
#
# http://www.mozilla.org/mailnews/arch/mork/primer.txt
# http://jwz.livejournal.com/312657.html
# http://www.jwz.org/doc/mailsum.html
# http://bugzilla.mozilla.org/show_bug.cgi?id=241438
#
# In brief, let's count its sins:
#
# - Two different numerical namespaces that overlap.
#
# - It can't decide what kind of character-quoting syntax to use:
# Backslash? Hex encoding with dollar-sign?
#
# - C++ line comments are allowed sometimes, but sometimes // is just
# a pair of characters in a URL.
#
# - It goes to all this serious compression effort (two different
# string-interning hash tables) and then writes out Unicode strings
# without using UTF-8: writes out the unpacked wchar_t characters!
#
# - Worse, it hex-encodes each wchar_t with a 3-byte encoding,
# meaning the file size will be 3x or 6x (depending on whether
# whchar_t is 2 bytes or 4 bytes.)
#
# - It masquerades as a "textual" file format when in fact it's just
# another binary-blob file, except that it represents all its magic
# numbers in ASCII. It's not human-readable, it's not hand-editable,
# so the only benefit there is to the fact that it uses short lines
# and doesn't use binary characters is that it makes the file bigger.
# Oh wait, my mistake, that isn't actually a benefit at all.
#
# Pure comedy.
#
##############################################################################


require 5;
use diagnostics;
use strict;
use POSIX qw(strftime);

my $progname = $0; $progname =~ s@.*/@@g;
my $version = q{ $Revision: 1.14 $ }; $version =~ s/^[^0-9]+([0-9.]+).*$/$1/;

my $verbose = 0;
my $show_all_p = 1;

my (%key_table, %val_table, %row_hash);
my ($total, $skipped) = (0, 0);

# Returns a list of hashes, the contents of the mork file.
#
sub mork_parse_file {
my ($file, $age) = @_;
local $/ = undef;
local *IN;

my $since = ($age ? time() - $age : 0);

##########################################################################
# Define the messy regexen up here
##########################################################################

my $top_level_comment = qr@//.*\n@;

my $key_table_re = qr/ < \s* < # "< <"
\( a=c \) > # "(a=c)>"
(?> ([^>]*) ) > \s* # Grab anything that's not ">"
/sx;

my $value_table_re = qr/ < ( .*?\) )> \s* /sx;

my $table_re = qr/ \{ -? # "{" or "{-"
[\da-f]+ : # hex, ":"
(?> .*?\{ ) # Eat up to a {...
((?> .*?\} ) # and then the closing }...
(?> .*?\} )) # Finally, grab the table section
\s* /six;

my $row_re = qr/ ( (?> \[ [^]]* \] # "["..."]"
\s*)+ ) # Perhaps repeated many times
/sx;

my $section_begin_re = qr/ \@\$\$\{ # "@$${"
([\dA-F]+) # hex
\{\@ \s* # "{@"
/six;

my $section_end_re = undef;
my $section = "top level";

##########################################################################
# Read in the file.
##########################################################################
open (IN, "<$file") || error ("$file: $!");
print STDERR "$progname: reading $file...\n" if ($verbose);

my $body = <IN>;
close IN;

$body =~ s/\r\n/\n/gs; # Windows Mozilla uses \r\n
$body =~ s/\r/\n/gs; # Presumably Mac Mozilla is similarly dumb

$body =~ s/\\\\/\$5C/gs; # Sometimes backslash is quoted with a
# backslash; convert to hex.
$body =~ s/\\\)/\$29/gs; # close-paren is quoted with a backslash;
# convert to hex.
$body =~ s/\\\n//gs; # backslash at end of line is continuation.

##########################################################################
# Figure out what we're looking at, and parse it.
##########################################################################

print STDERR "$progname: $file: parsing...\n" if ($verbose);

pos($body) = 0;
my $length = length($body);

while( pos($body) < $length ) {

# Key table

if ( $body =~ m/\G$key_table_re/gc ) {
mork_parse_key_table($file, $section, $1);

# Values
} elsif ( $body =~ m/\G$value_table_re/gco ) {
mork_parse_value_table($file, $section, $1);

# Table
} elsif ( $body =~ m/\G$table_re/gco ) {
mork_parse_table($file, $section, $age, $since, $1);

# Rows (-> table)
} elsif ( $body =~ m/\G$row_re/gco ) {
mork_parse_table($file, $section, $age, $since, $1);

# Section begin
} elsif ( $body =~ m/\G$section_begin_re/gco ) {
$section = $1;
$section_end_re = qr/\@\$\$\}$section\}\@\s*/s;

# Section end
} elsif ( $section_end_re && $body =~ m/\G$section_end_re/gc ) {
$section_end_re = undef;
$section = "top level";

# Comment
} elsif ( $body =~ m/\G$top_level_comment/gco ) {
#no-op

} else {
# $body =~ m/\G (.{0,300}) /gcsx; print "<$1>\n";
error("$file: $section: Cannot parse");
}
}

if($section_end_re) {
error("$file: Unterminated section $section");
}


print STDERR "$progname: $file: sorting...\n" if ($verbose);

my @entries = sort { $b->{LastVisitDate} <=>
$a->{LastVisitDate} } values(%row_hash);

print STDERR "$progname: $file: done! ($total total, $skipped skipped)\n"
if ($verbose);

(%key_table, %val_table, %row_hash, $total, $skipped) = ();

return \@entries;
}


##########################################################################
# parse a row and column table
##########################################################################

sub mork_parse_table {
my($file, $section, $age, $since, $table_part) = (@_);

print STDERR "\n" if ($verbose > 3);

# Assumption: no relevant spaces in values in this section
$table_part =~ s/\s+//g;

# print $table_part; #exit(0);

#Grab each complete [...] block
while( $table_part =~ m/\G [^[]* \[ # find a "["
( [^]]+ ) \] # capture up to "]"
/gcx ) {
$_ = $1;

my %hash;
my ($id, @cells) = split (m/[()]+/s);

next unless scalar(@cells);

# Trim junk
$id =~ s/^-//;
$id =~ s/:.*//;

if($row_hash{$id}) {
%hash = ( %{$row_hash{$id}} );
} else {
%hash = ( 'ID' => $id,
'LastVisitDate' => 0 );
}

foreach (@cells) {
next unless $_;

my ($keyi, $which, $vali) =
m/^\^ ([-\dA-F]+)
([\^=])
(.*)
$/xi;

error ("$file: unparsable cell: $_\n") unless defined ($vali);

# If the key isn't in the key table, ignore it
#
my $key = $key_table{$keyi};
next unless defined($key);

my $val = ($which eq '='
? $vali
: $val_table{$vali});

if ($key eq 'LastVisitDate' || $key eq 'FirstVisitDate') {
$val = int ($val / 1000000); # we don't need milliseconds, dude.
}

$hash{$key} = $val;
#print "$id: $key -> $val\n";
}


if ($age && ($hash{LastVisitDate} || $since) < $since) {
print STDERR "$progname: $file: skipping old: " .
"$hash{LastVisitDate} $hash{URL}\n"
if ($verbose > 3);
$skipped++;
next;
}

$total++;
$row_hash{$id} = \%hash;
}
}


##########################################################################
# parse a values table
##########################################################################

sub mork_parse_value_table {
my($file, $section, $val_part) = (@_);

return unless $val_part;

my @pairs = split (m/\(([^\)]+)\)/, $val_part);
$val_part = undef;

print STDERR "\n" if ($verbose > 3);

foreach (@pairs) {
next unless (m/[^\s]/s);
my ($key, $val) = m/([\dA-F]*)[\t\n ]*=[\t\n ]*(.*)/i;

if (! defined ($val)) {
print STDERR "$progname: $file: $section: unparsable val: $_\n";
next;
}

# Assume that URLs and LastVisited are never hexilated; so
# don't bother unhexilating if we won't be using Name, etc.
if($show_all_p && $val =~ m/\$/) {
# Approximate wchar_t -> ASCII and remove NULs
$val =~ s/\$00//g; # faster if we remove these first
$val =~ s/\$([\dA-F]{2})/chr(hex($1))/ge;
}

$val_table{$key} = $val;
print STDERR "$progname: $file: $section: val $key = \"$val\"\n"
if ($verbose > 3);
}
}


##########################################################################
# parse a key table
##########################################################################

sub mork_parse_key_table {
my ($file, $section, $key_table) = (@_);

print STDERR "\n" if ($verbose > 3);
$key_table =~ s@\s+//.*$@@gm;

my @pairs = split (m/\(([^\)]+)\)/s, $key_table);
$key_table = undef;

foreach (@pairs) {
next unless (m/[^\s]/s);
my ($key, $val) = m/([\dA-F]+)\s*=\s*(.*)/i;
error ("$file: $section: unparsable key: $_") unless defined ($val);

# If we're only emitting URLs and dates, don't even bother
# saving the other fields that we aren't interested in.
#
next if (!$show_all_p &&
$val ne 'URL' && $val ne 'LastVisitDate' &&
$val ne 'VisitCount');

$key_table{$key} = $val;
print STDERR "$progname: $file: $section: key $key = \"$val\"\n"
if ($verbose > 3);
}
}


sub html_quote {
my ($s) = @_;
$s =~ s/&/&amp;/g;
$s =~ s/</&lt;/g;
$s =~ s/>/&gt;/g;
$s =~ s/\"/&quot;/g;
return $s;
}

sub html_wrap {
my ($s) = @_;
$s = html_quote ($s);

# while there are non-wrappable chunks of 30 characters,
# insert wrap points at certain punctuation characters every 10 characters.
while ($s =~ m/[^\s]{30}/s) {
last unless ($s =~ s@([^\s]{10})([/;,])([^/\s])@$1$2 $3@gs ||
$s =~ s@([^\s]{10})([-_\$\#?.]|&amp;|%(2F|2C|26))@$1 $2@gs);
}

# if we still have non-wrappable chunks of 40 characters,
# insert wrap points every 30 characters no matter what.
while ($s =~ m/[^\s]{40}/s) {
last unless ($s =~ s@([^\s]{30})@$1 @gs);
}

return $s;
}

sub format_urls {
my ($results, $html_p) = @_;

print "<TABLE BORDER=0 CELLPADDING=" . ($show_all_p ? "4" : "0") .
" CELLSPACING=0>\n"
if ($html_p);

foreach my $hash (@$results) {

if ($show_all_p) {
#
# Print every field in the hash.
#

if ($html_p) {
print " <TR>\n";
print " <TD NOWRAP ALIGN=RIGHT VALIGN=TOP>$hash->{ID}&nbsp;</TD>\n";
print " <TD NOWRAP>\n";
print " <TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0>\n";
}

my %key_sort_table = (
'ID' => ' 0 ',
'URL' => ' 1 ',
'Name' => ' 2 ',
'Hostname' => ' 3 ',
'FirstVisitDate' => ' 4 ',
'LastVisitDate' => ' 5 '
);

foreach my $key (sort { ($key_sort_table{$a} || $a) cmp
($key_sort_table{$b} || $b)
} (keys(%$hash))) {
my $val = $hash->{$key};
if ($key eq 'LastVisitDate' || $key eq 'FirstVisitDate') {
$val = localtime ($val);
}
if ($html_p) {
next if ($key eq 'ID');
$key = html_quote ($key);
$val = ($key eq 'URL'
? "<A HREF=\"$val\">" . html_wrap ($val) . "</A>"
: html_wrap ($val));
print " <TR>\n";
print " <TD VALIGN=TOP NOWRAP ALIGN=RIGHT>$key: &nbsp;</TD>\n";
print " <TD VALIGN=TOP>$val</TD>\n";
print " </TR>\n";
} else {
print sprintf ("%14s = %s\n", $key, $val);
}
}

if ($html_p) {
print " </TABLE>\n";
print " </TD>\n";
print " </TR>\n";
}
print "\n";

} else {
#
# Print just the URLs and their last-load-times.
#
my $url = $hash->{'URL'};
my $date = $hash->{'LastVisitDate'} || 0;
my $count = $hash->{'VisitCount'} || 1;
next unless defined ($url);

if ($html_p) {
$date = strftime("%d %b %l:%M %p", localtime ($date));
my $u2 = html_wrap ($url);
print " <TR>";
print "<TD VALIGN=TOP ALIGN=RIGHT NOWRAP>";
print "($count) " if ($count > 1);
print "$date &nbsp;</TD>";
print "<TD VALIGN=TOP><A HREF=\"$url\">$u2</A></TD>";
print "</TR>\n";
} else {
print "$date\t$count\t$url\n";
}
}
}

print "</TABLE>\n" if ($html_p);
}


sub error {
($_) = @_;
print STDERR "$progname: $_\n";
exit 1;
}

sub usage {
print STDERR "usage: $progname [--verbose] [--html] [--age secs] " .
"mork-input-file\n" .
"\t'age' can be of the form '2h', '3d', etc.\n";
exit 1;
}

sub main {
my ($file, $age, $html_p);
while ($#ARGV >= 0) {
$_ = shift @ARGV;
if ($_ eq "--verbose") { $verbose++; }
elsif (m/^-v+$/) { $verbose += length($_)-1; }
elsif ($_ eq "--age") { $age = shift @ARGV; }
elsif ($_ eq "--html") { $html_p = 1; }
elsif (m/^-./) { usage; }
elsif (!defined($file)) { $file = $_; }
else { usage; }
}

usage() unless defined($file);

$show_all_p = ($verbose > 1);

if (!$age) {
} elsif ($age =~ m/^(\d+)\s*s(ec(onds?)?)?$/i) {
$age = $1 + 0;
} elsif ($age =~ m/^(\d+)\s*m(in(utes?)?)?$/i) {
$age = $1 * 60;
} elsif ($age =~ m/^(\d+)\s*h(ours?)?$/i) {
$age = $1 * 60 * 60;
} elsif ($age =~ m/^(\d+)\s*d(ays?)?$/i) {
$age = $1 * 60 * 60 * 24;
} elsif ($age =~ m/^(\d+)\s*w(eeks?)?$/i) {
$age = $1 * 60 * 60 * 24 * 7;
} elsif ($age =~ m/^(\d+)\s*m(on(ths?)?)?$/i) {
$age = $1 * 60 * 60 * 24 * 30;
} elsif ($age =~ m/^(\d+)\s*y(ears?)?$/i) {
$age = $1 * 60 * 60 * 24 * 365;
} else {
error ("unparsable: --age $age");
}

my $results = mork_parse_file ($file, $age);
format_urls ($results, $html_p);
}

main;
exit 0;




syntax highlighted by Code2HTML, v. 0.9.1

2008-01-09

Installing code2html on Ubuntu


1 cd /home/user/OperaDownloads/
2 mv code2html.tar.gz /var/www/
3 cd /var/www
4 tar -xvf code2html.tar.gz
5 cd code2html-0.9.1/
6 cd INSTALL
7 vim INSTALL
8 cd ..
9 ls -al
10 cd code2html-0.9.1/
11 ls -al
12
13 mv code2html /usr/bin
14 fg
15 chmod 755 /usr/bin/code2html
16 ls -al /usr/bin/code2html
17 chown root:root /usr/bin/code2html
18 ls -al /usr/local/man/man1
19 ls -al /usr/local/man/
20
21 mv code2html-0.9.1/ /usr/share/doc/code2html
22 ls -alr /usr/share/doc/code2html
23 fg
24 less /usr/share/doc/code2html/INSTALL
25 man code2html
26 mkdir /usr/local/man/man1
27 mv /usr/local/man/code2html.1 /usr/local/man/man1
28 man code2html
29 cat /usr/bin/code2html > /var/www/tmp.log
30 code2html -l perl /var/www/tmp.log /var/www/tmp.html




syntax highlighted by Code2HTML, v. 0.9.1

mysql höpölöpö


1 MySQL
2
3 echo Start the mysql as the root user using SecretPass password
4
5 echo Note that the clear command does not work from the shell so use the Ctrl + l shortcut to clear the messy screen
6 [mysql dir]/bin/mysql -h hostname -u root -p SecretPass
7
8 echo show the existing databases on this host (show present something like this )
9
10 show databases ;
11
12 mysql> show databases ;
13 +--------------------+
14 | Database |
15 +--------------------+
16 | information_schema |
17 | mysql |
18 +--------------------+
19 5 rows in set (0.00 sec)
20
21
22
23 echo running mysql in batch mode
24
25 shell> mysql -h host -u user -pSecretPass < /path/to/batch-file
26
27 ou can catch the output in a file for further processing:
28 shell> mysql < batch-file > mysql.out
29
30
31
32 DROP DATABASE `db_transpub` ;
33 CREATE DATABASE `db_transpub` DEFAULT CHARACTER SET utf8 ;
34 use db_transpub ;
35 DROP TABLE IF EXISTS `tb_contactDetails`;
36 CREATE TABLE `tb_contactDetails` (firstname VARCHAR(20), middlename VARCHAR(20), lastname VARCHAR(35),officeid VARCHAR(10),username VARCHAR(8),email VARCHAR(35),phone VARCHAR(25), groups
37 VARCHAR(15),datestamp DATE,timestamp time, userId VARCHAR(15), PRIMARY KEY (`userId`));
38
39
40 miscelanious
41 echo how to get the version of mysql select version() phpMyAdmin provides php interface to mysql database(s)
42 MySQL Cheat Sheet
43
44 http://dev.mysql.com/doc/
45
46 search the documentation
47
48 To login (from unix shell) use -h only if needed.
49
50 [mysql dir]/bin/mysql -h hostname -u root -p
51 Create a database on the sql server.
52
53 create database [databasename];
54 List all databases on the sql server.
55
56 show databases;
57 Switch to a database.
58
59 use [db name];
60 To see all the tables in the db.
61
62 show tables;
63 To see database field formats.
64
65 describe [table name];
66 To delete a db.
67
68 drop database [database name];
69 To delete a table.
70
71 drop table [table name];
72 Show all data in a table.
73
74 SELECT * FROM [table name];
75 Returns the columns and column information pertaining to the designated table.
76
77 show columns from [table name];
78 Show certain selected rows with the value "whatever".
79
80 SELECT * FROM [table name] WHERE [field name] = "whatever";
81 Show all records containing the name "Bob" AND the phone number '3444444'.
82
83 SELECT * FROM [table name] WHERE name = "Bob" AND phone_number = '3444444';
84 Show all records not containing the name "Bob" AND the phone number '3444444' order by the phone_number field.
85
86 SELECT * FROM [table name] WHERE name != "Bob" AND phone_number = '3444444' order by phone_number;
87 Show all records starting with the letters 'bob' AND the phone number '3444444'.
88
89 SELECT * FROM [table name] WHERE name like "Bob%" AND phone_number = '3444444';
90 Use a regular expression to find records. Use "REGEXP BINARY" to force case-sensitivity. This finds any record beginning with a.
91
92 SELECT * FROM [table name] WHERE rec RLIKE "^a$";
93 Show unique records.
94
95 SELECT DISTINCT [column name] FROM [table name];
96 Show selected records sorted in an ascending (asc) or descending (desc).
97
98 SELECT [col1],[col2] FROM [table name] ORDER BY [col2] DESC;
99 Return number of rows.
100
101 SELECT COUNT(*) FROM [table name];
102 Sum column.
103
104 SELECT SUM(*) FROM [table name];
105 Join tables on common columns.
106
107 select lookup.illustrationid, lookup.personid,person.birthday from lookup
108 left join person on lookup.personid=person.personid=statement to join birthday in person table with primary illustration id;
109 Switch to the mysql db. Create a new user.
110
111 INSERT INTO [table name] (Host,User,Password) VALUES('%','user',PASSWORD('password'));
112 Change a users password.(from unix shell).
113
114 [mysql dir]/bin/mysqladmin -u root -h hostname.blah.org -p password 'new-password'
115 Change a users password.(from MySQL prompt).
116
117 SET PASSWORD FOR 'user'@'hostname' = PASSWORD('passwordhere');
118 Allow the user "bob" to connect to the server from localhost using the password "passwd"
119
120 grant usage on *.* to bob@localhost identified by 'passwd';
121 Switch to mysql db.Give user privilages for a db.
122
123 INSERT INTO [table name] (Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv) VALUES ('%','databasename','username','Y','Y','Y','Y','Y','N');
124
125 or
126
127 grant all privileges on databasename.* to username@localhost;
128 To update info already in a table.
129
130 UPDATE [table name] SET Select_priv = 'Y',Insert_priv = 'Y',Update_priv = 'Y' where [field name] = 'user';
131 Delete a row(s) from a table.
132
133 DELETE from [table name] where [field name] = 'whatever';
134 Update database permissions/privilages.
135
136 FLUSH PRIVILEGES;
137 Delete a column.
138
139 alter table [table name] drop column [column name];
140 Add a new column to db.
141
142 alter table [table name] add column [new column name] varchar (20);
143 Change column name.
144
145 alter table [table name] change [old column name] [new column name] varchar (50);
146 Make a unique column so you get no dupes.
147
148 alter table [table name] add unique ([column name]);
149 Make a column bigger.
150
151 alter table [table name] modify [column name] VARCHAR(3);
152 Delete unique from table.
153
154 alter table [table name] drop index [colmn name];
155 Load a CSV file into a table.
156
157 LOAD DATA INFILE '/tmp/filename.csv' replace INTO TABLE [table name] FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1,field2,field3);
158 Dump all databases for backup. Backup file is sql commands to recreate all db's.
159
160 [mysql dir]/bin/mysqldump -u root -ppassword --opt >/tmp/alldatabases.sql
161 Dump one database for backup.
162
163 [mysql dir]/bin/mysqldump -u username -ppassword --databases databasename >/tmp/databasename.sql
164 Dump a table from a database.
165
166 [mysql dir]/bin/mysqldump -c -u username -ppassword databasename tablename > /tmp/databasename.tablename.sql
167 Restore database (or database table) from backup.
168
169 [mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql
170 Create Table Example 1.
171
172 CREATE TABLE [table name] (firstname VARCHAR(20), middleinitial VARCHAR(3), lastname VARCHAR(35),suffix VARCHAR(3),officeid VARCHAR(10),userid VARCHAR(15),username VARCHAR(8),email VARCHAR(35),phone VARCHAR(25), groups
173 VARCHAR(15),datestamp DATE,timestamp time,pgpemail VARCHAR(255));
174 Create Table Example 2.
175
176 create table [table name] (personid int(50) not null auto_increment primary key,firstname varchar(35),middlename varchar(50),lastnamevarchar(50) default '
bato');
177
178 ;who has what priviledges
179
180 show grants ;
181
182
183 simple setup of php based web interface to a mysql database
184
185 This tutorial uses Ubuntu 7.10 the Gutsy Gibbon, Apache 2.0 , php5 and mysql
186
187 The follwoing main phpases are used:
188
189
190
191 - install Apache
192
193 - install mysql
194
195 - configure mysql - add users , create databases on mysql
196
197 - configure Apache
198
199 - install myPhpAdmin
200
201 - configure myPhpAdmin
202
203
204
205 1.Install Apache
206
207 #INSTALL APACHE
208
209 sudo apt-get install apache2
210
211 #Start or stop Apache
212 sudo /etc/init.d/apache2 stop | start | restart
213 #if installation of previous packages has failed
214 dpkg --configure -a
215
216 #install PHP mod_php for Apache
217 sudo apt-get install php5 libapache2-mod-php5
218
219 echo '
<?php echo "Haaudi World"; ?>' > /var/www/test.php
220 open http://localhost/test.php - > you should see Haudi World
221
222 2. Install mySQL
223
224 #if installation of previous packages has failed
225
226 dpkg --configure -a
227 sudo /etc/init.d/apache2 stop | start | restart
228
229 #install mysql server
230 sudo apt-get install mysql-server
231 #when prompted type in your password
232
233 #if not prompted the command to get to the mysql prompt is :
234
235 mysql -uroot -pmysql
236
237 #set the password with the following:
238 mysql> SET PASSWORD FOR '
root'@'localhost' = PASSWORD('SecretPass');
239 #run the mysql with:
240 mysql -uroot -pSecretPass
241
242 #view the databases
243
244 show databases ;
245
246 #create a database with one table
247
248 create database testdb ;
249
250 use db_test
251
252 CREATE TABLE tb_testtable(
253 column0 INT PRIMARY KEY AUTO_INCREMENT,
254 column1 VARCHAR(100),
255 column2 VARCHAR(10) ) TYPE=INNODB;
256
257 3. Intall php
258
259 #install the php admin
260 sudo apt-get install libapache2-mod-auth-mysql php5-mysql
261 #when prompted configure the type of servers
262
263 #Other php modules usefull for development
264 apt-get install php5-gd
265 apt-get install php5-ldap
266 apt-get install php5-mysql
267 apt-get install php5-openssl
268 apt-get install php5-pear
269
270 4. Install phpMyAdmin
271
272 Download the latest stable build of phpMyAdmin [[http://surfnet.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.11.3-all-languages.tar.bz2]]
273
274 #place the tar under a phpMyAdmin folder (you would have to create it mkdir /var/www/phpMyAdmin ) under your doc root folder
275
276 mv /home/user/downloads/phpMyAdmin-2.11.3-all-languages/ /var/www/phpMyAdmin
277
278 tar -xvf phpMyAdmin-2.11.3-all-languages.tar.bz2
279
280 #configure the most sipliest (not sucure !!!) setup
281
282 vim /var/www/phpMyAdmin/config.inc.php
283
284 paste the following code in it:
285
286 ==============================COPY PASTE START
287
288 <?php
289
290 $cfg['
blowfish_secret']='shazaam' ; // use here a value of your choice
291 $i=0;
292 $i++;
293 $cfg['
Servers'][$i]['auth_type'] = 'cookie';
294 ?>
295
296 ==============================COPY PASTE END
297
298 Go to the login page :
299
300 http://localhost/phpMyAdmin/
301
302 Login in with the same password you set up during the mysql configuration(here user:root pass:SecretPass)
303
304




syntax highlighted by Code2HTML, v. 0.9.1

Labels

perl (41) Cheat Sheet (25) how-to (24) windows (14) sql server 2008 (13) linux (12) oracle (12) sql (12) Unix (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) bash (6) code generation (6) Informatica (5) cheatsheet (5) energy (5) tsql (5) utilities (5) excel (4) future (4) generic (4) git cheat sheet (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) logging (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) architecture (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) informatica sql repository (2) linux cheat sheet (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) IDEA (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture input output (1) archive (1) arguments (1) avatar (1) aws cheat sheet cli (1) aws cli (1) aws cli amazon cheat sheet (1) aws elb (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy paste (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) isg-pub issue-tracker architecture (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) openssl (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scala ScalaFmt (1) scp (1) scripts (1) scsi (1) search and replace (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smells (1) smtp (1) software development (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) system design (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux .tmux.conf configuration (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vbox virtual box cheat sheet (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List