Migrating greek table from mysql < 4.1

I do not remember how the tables were transferred from the old DB to the new (more likely through a mysqldump).

The end effect was that the tables in the 4.1 MySql Db had a collation of latin1_swedish_ci.

After backing up the affected tables, do:



Just make sure you return the column type at exactly what was before you made it a blob.

Now the columns should have a collation of greek_general_ci

Furthermore, in case the php scripts gives you trouble loading the new rows, try something like:



The above example was run in some AdoDB Phakt scripts, but the gist of it is before any selects run the above sql commands.

Good luck...

Passwordless ssh connection with another server

First, create the key on the local machine (without a passphrase)



Then create a directory on the remote machine:



Finally append new key to remote .ssh/authorized_keys file:



Note

In place of the last command you could have also used:



but in the case your public key file does not contain a newline character at the end of the file (which probably it does not) the final concatenation on the `authorized_keys` will end up with long text line without newlines between the keys, thus making the file invalid. Tee on the other hand prepends the concatenation with a newline, keeping `authorized keys` happy.