One very helpful use of the technique Sheeri described in Remote connections without leaving the mysql shell is making sure that replication is working properly.

According to the MySQL Reference Manual’s section on SHOW SLAVE STATUS Syntax, it shows information corresponding to the slave thread in the slave server. When replication is broken, however, or not working properly due to network issues between master and slave, this information may not be accurate. This has improved over recent releases, but it’s still not perfect.

The question, then, is: how to be 100% sure (or as close as you can get to 100%) that replication is running fine? The answer, as offered by Sheeri: use CONNECT.

Example …

You probably know that mysql -h host_or_ip can connect you to a remote host.

But did you know that you can change the host you are connected to from within mysql?

The undocumented (as far as I can tell, in the MySQL manual and in the “help” on the mysql command line) CONNECT statement can help.
(more…)

Background Knowledge

Today (2008-01-12) I loaded Pidgin and discovered that I was no longer able to connect to MSN. It appears either Microsoft is blocking the connection or a new version has been release. What the cause of the matter is I have not been able to verify with certainty at this time.

UPDATE: Pidgin v2.5.4 has been released that temporarily fixes the problem.

Error Message

“Unable to Retrieve MSN Address Book using Pidgin”. See screen shot of the error message below.

Solution

1. Close Pidgin application.
2. Download and install “msn-pecan“.
3. Run Pidgin application.
4. In Pidgin “Show Buddy List” and go to the menu “Accounts” -> “Manage Accounts”.
5. Modify your MSN account, ensure the protocol shows “MSN”.
…

If you are a Drupal user and have been wanting to develop Facebook Applications using Facebook APIs or Facebook Connect, there is Good News. Dave Cohen just released a Drupal for Facebook  add-on module for Drupal which allows Drupal sites to integrate with Facebook, and cutting-edge Facebook Applications to be built on top of Drupal. I attended a Drupal meetup yesterday where Dave walked us through how to build Drupal Apps for Facebook and it was very clear that Dave has put in tremdous amount of work and due diligence to make it easy for rest of the community to easily plug into Facebook. Try it out!

Sun is offering Drupal/Open …

If you are a Drupal user and have been wanting to develop Facebook Applications using Facebook APIs or Facebook Connect, there is Good News. Dave Cohen just released a Drupal for Facebook  add-on module for Drupal which allows Drupal sites to integrate with Facebook, and cutting-edge Facebook Applications to be built on top of Drupal. I attended a Drupal meetup yesterday where Dave walked us through how to build Drupal Apps for Facebook and it was very clear that Dave has put in tremdous amount of work and due diligence to make it easy for rest of the community to easily plug into Facebook. Try it out!

Sun is offering Drupal/Open …

If you are a Drupal user and have been wanting to develop Facebook Applications using Facebook APIs or Facebook Connect, there is Good News. Dave Cohen just released a Drupal for Facebook  add-on module for Drupal which allows Drupal sites to integrate with Facebook, and cutting-edge Facebook Applications to be built on top of Drupal. I attended a Drupal meetup yesterday where Dave walked us through how to build Drupal Apps for Facebook and it was very clear that Dave has put in tremdous amount of work and due diligence to make it easy for rest of the community to easily plug into Facebook. Try it out!

Sun is offering Drupal/Open …