Dedicated Servers / Daemon / 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 ...
Dedicated Servers / Daemon / 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 ...
Dedicated Servers / Daemon / 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 ...
Dedicated Servers / Daemon / 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 ...
Dedicated Servers / Daemon / 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 ...
Dedicated Servers / Daemon / 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 ...
Dedicated Servers / Daemon / MySQL How to show MySQL version? Answer: just run this query:
select version(); ...
Monitoring / 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 ...
Dedicated Servers / Linux / 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 ...
Dedicated Servers / 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 ...