2007-02-02 Branching in SVN with existing work
This week I had the situation where I was asked to come to another office (in Groningen) and do some . . . $ patch -p 0 < ~/gron.patch patching file tdb/mysql-telis.sql patching file client/python/plotffo.py . . . ... lines removed ... Sending tdb/mysql-telis.sql Transmitting file data ..... Committed . . .
2K - last updated 2007-02-02 13:59 UTC by bvankuik
2008-05-25 Finding open ports
When tightening up security on a Linux server, one of the first things the system administrator does, . . . 0 telislt.sron.:commplex-main 6573/ssh tcp 0 0 *:mysql 2307/mysqld tcp 0 0 *:sunrpc 1945/rpcbind tcp . . .
3K - last updated 2008-05-25 20:25 UTC by 6130
2012-01-23 Logrotate error for MySQL on Debian 6 Squeeze
When installing a new machine with Debian 6 (Squeeze), I also imported a database from a CentOS 5 box. . . . running shared postrotate script for '/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log . . . create the user with the following commands: $ mysql -u root -p mysql> GRANT SHUTDOWN ON *.* TO 'debian-sys-maint'@'localhost'; . . . mysql> GRANT RELOAD ON *.* TO 'debian-sys-maint'@'localhost'; . . . mysql> GRANT SELECT ON 'mysql'.'user' TO 'debian-sys-maint'@'localhost'; . . .
2K - last updated 2012-01-23 07:38 UTC by 6130
2012-11-09 Full-text searching
In a previous project, I solved the full text search problem as follows. Management overview: it's very . . . but very hard to assign a weight to the results. MySQL supports full-text search but only in a degraded . . . name, address, reviews, locations etc). The MySQL full-text search facility then becomes available, . . . Then, this table can be searched by the MySQL facility "full text search", and give you back . . .
2K - last updated 2012-11-09 06:03 UTC by 6130
Bash
= Online resources = [http://ldp.nl.uu.net/LDP/abs/html/ Advanced Bash-Scripting Guide] = Changing numbering . . . as another user in a script run by root: su mysql -c mysql_install_db If you want to run multiple . . . commands, a HERE document is very useful: su - mysql <<HERE execute some commands as user HERE Be . . .
10K - last updated 2012-09-14 07:29 UTC by 6130
Debian
= Package tools = == dpkg-query == This command is meant to query the package database. Some examples: . . . See if some packages, with the string mysql in the name, are installed or not: $ dpkg-query . . . -l '*mysql*' == dpkg == The dpkg command is at its core . . . which provides a certain file: $ apt-file search mysql.h Or use the web frontend at http://www.debian.org/distrib/packages#search_contents . . .
6K - last updated 2014-01-10 12:17 UTC by 6130
Linux links
* http://www.packetfu.org/hpl.html * http://edseek.com/~jasonb/articles/traffic_shaping/ * [http://fas.sfu.ca/dataface . . . a generic package for creating screens on top of MySQL tables . . .
1K - last updated 2007-01-23 12:06 UTC by 6130
MySQL
= Installation = Install as usual for your distribution. For Debian, this means: $ sudo apt-get install . . . == Setting passwords == After installation of MySQL, set root password as follows: $ mysqladmin -u . . . root password NEWPASSWORD If you prefer the mysql client: $ mysql -u root mysql> SET PASSWORD FOR . . . = PASSWORD('secret'); == Resetting the MySQL root password == The following procedure works . . . following lines, and adjust the password: UPDATE mysql.user SET Password=PASSWORD('my_new_password') . . .
8K - last updated 2023-01-30 09:45 UTC by bartvk
PHP
= Standard Packages = Use the PEAR classes, http://pear.php.net/ = Secure programming = Check out the . . . * 20)/20; = Default date = This is more of a MySQL issue, but apparently until version 5.1 of MySQL, . . .
2K - last updated 2009-02-13 20:15 UTC by 6130
Performance
The subject is: performance measurement of a Linux server. = Measuring bandwidth = First, create a file . . . --sort=rss | sort -n -r | head = Scaling down MySQL = On a default Redhat or CentOS installation, . . . MySQL memory consumption looks roughly as follows: . . . # ps -e -o rss,cmd | grep -i mysql 38396 /usr/libexec/mysqld Put the following entries . . . in the /etc/my.cnf file, under the [mysqld] section: innodb_buffer_pool_size = 128k key_buffer_size . . .
6K - last updated 2013-12-20 08:02 UTC by 6130
RT
= Installation on Debian = Install apache, fastcgi, mysql ... from woody. libcgi-fast-perl libfcgi-perl . . . perl-suid libmysqlclitn10-dev deb http://www.backports.org/debian . . . stable mysql-dfsg http://www.bestpractical.com/rt/draftmanual.pdf . . . perl sbin/rt-test-dependencies --with-mysql --with-fastcgi run perl -MCPAN -e shell and configure . . . perl sbin/rt-test-dependencies --with-mysql --with-fastcgi --install it will install almost . . .
3K - last updated 2006-03-01 09:27 UTC by 6130
SQL
= Oracle's decode in MySQL = I have an Oracle background where a decode instruction was never far away. . . . Nowadays I use MySQL for lots of stuff and when I needed a decode, . . .
1K - last updated 2007-10-30 13:59 UTC by 6130
SVN
I've written about the differences between SVN and CVS and the usage of the plugins in Eclipse, see also . . . $ patch -p 0 < ~/gron.patch patching file tdb/mysql-telis.sql patching file client/python/plotffo.py . . .
17K - last updated 2014-04-11 10:18 UTC by 6130
mysql
[[MySQL]] . . .
1K - last updated 2013-08-09 10:11 UTC by 6130
vankuik.nl
= Latest weblog entries = <journal 5> = Weblog Archive = [[Weblog_entries_2024]] [[Weblog_entries_2023]] . . . * [[Perl]] * [[PHP]] * [[Python]] * [[MySQL]] but mostly the administrative side * [[SQL]] . . .
4K - last updated 2024-04-16 10:29 UTC by bartvk
15 pages found.