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 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 ...
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 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 ...