dirkgomez.de

$Author$ $Date$ $Id$ $Revision$ $Source$ $Log$

cvs diff -r old_version -r new_version filename

cvs up -C filenames

cvs co -D yesterday projectname

cvs co -d target_directory_name projectname

You can edit $CVSROOT/cvswrapper and add extentions of binary files to it, so that you don't need to give the -kb switch for these files anymore

The Typo3 extension tt_news is causing problems with indexed_search. The table index_rel grows quickly to an enormous size, 28 million rows on one of my sites. This caused two problems:

• the nightly backups took a lot of time, the automated restore on the standby machine wouldn't even finish anymore.
• Typo3 search generated huge SQL queries that would bring down the MySQL server.

There is a lot of content on this site, but nowhere near 28 million "items" (whatever is in index_rel I do not know).

I frequently work in environments where people rather use Notepad than Emacs and then freely commit their changes to the subversion repository. If you then diff your file against the one in the repository, you would get a diff for each line. Subversion can ignore newline style and whitespace diffs with this command: svn diff -x --ignore-eol-style

If your flavor of Unix doesn't come with ssh-copy-id - does only Debian have it? - , then create a file called ssh-copy-id in your $PATH with:

cat ~/.ssh/*.pub | ssh $1 'mkdir .ssh; chmod 700 .ssh; cat>>.ssh/authorized_keys'

You can then copy your public key to another machine by running ssh-copy-id remoteuser@remotehostname.

So entfernt man Duplikate in einer Oracle-Datenbanktabelle mit Hilfe von "Analytical SQL": delete from tabelle where rowid in (select rowid from (select rowid, row_number() over (partition by feld1,feld2 order by feld1, feld2) dup from tabelle ) where dup > 1);