MySQL: How to create MySQL dumps? Answer: As you have to move a MySQL database from one server to another you might run into troubles. Tools like phpMyAdmin may help you on ...
MySQL: How do I install MySQL 4.1 on Debian Etch / Debian 4.0? Answer: Hi Folks,I ran into that problem and here is a quite easy solution, thanks to www.mytso.net: edit /etc/apt/sources.list add the following line: deb http://debian.mytso.net/etch / edit /etc/apt/preferences add the following ...
MySQL: How to recover the MySQL root password? Answer: Well, this happens from time to time and is actually easy to fix, so here you are:
/etc/init.d/mysql stopmysqld_safe --skip-grant-tables &
mysql -u root
you should now be ...
Apache: How to install PHP 5.3 next to 5.2.x or 4.x? Answer: There are certain ways to achieve this, since the main reason for me doing that is testing, I choose the way with the least effort ...
Nagios: How to monitor MySQL replication with Nagios? Answer: Well, I wrote that script quite a while ago, it worked for me, so here you are:
#!/usr/bin/php -q
<?php
$host = $argv[1];
$user = $argv[2];
$pass = $argv[3];
$link = ...
Debian: How to install ruby / rubygems / passenger on Debian Squeeze / Lenny? Answer: Here are a few steps to get you started:
aptitude update
aptitude install ruby ruby1.8-dev irb rdoc build-essential mysql-client libmysql-ruby libmysqlclient15-dev
The enviroment is setup, now we ...
dbmail: How to install dbmail 3 from git on Debian Squeeze? Answer: Here are the steps to get you started (I put my stuff compiled from source into /usr/src):First of all we install a few libraries:
aptitude install ...
MySQL: How to change MySQL user password? Answer: Connect to your database and run the following command:
update mysql.user set password=PASSWORD("ENTER-PASSWORD-HERE") where User='ENTER-USERNAME';
After that you might want to run:
flush privileges;
...
Linux: How to edit a very large file? Answer: I had to remove one line of a 20GB MySQL dump file and was wondering how I could do this.
Actually there are a few ways, ...
dovecot: How to fix “Unknown database driver ‘mysql'"? Answer: If you didn´t compile dovecot from source, you need to install the dovecot-mysql package:
RedHat/CentOS/Fedora:
yum install dovecot-mysql
Debian:
apt-get install dovecot-mysql
If you compiled dovecot from source, you need ...