Here's a mini howto for lighttpd + svn + viewvc on Debian
Install viewvc
sudo apt-get install viewvc
Then you may be asked a few question about your location of svn and such, if you miss that, you can open /etc/viewrc/viewrc.conf and make sure you have svn_root set correctly, for example,
svn_roots = svn: /home/kcma/svn
Now edit /etc/lighttpd/lighttpd.conf, add mod_cgi to server.modules. Append a new section:
$HTTP["remoteip"] =~ "127.0.0.1" {
alias.url += ( "/viewsvn" => "/usr/lib/cgi-bin/viewvc.cgi" )
$HTTP["url"] =~ "^/viewsvn" {
cgi.assign = ( "" => "" )
}
}
Now you can access your svn repository via http://localhost/viewsvn
To reset the next auto increment value to the largest.
ALTER TABLE tbname AUTO_INCREMENT = 1;
Reset id:SET insert_id = x
where x is the number to use for the next auto increment.Renumber all the auto increased primary key:
ALTER TABLE mytable DROP myid;
ALTER TABLE mytable ADD myid INT NOT NULL AUTO_INCREMENT FIRST, ADD
PRIMARY KEY (myid), AUTO_INCREMENT=1;
GNU Screen
Reversed order using order_by: order_by=[desc(table.column)]
