# create ssh key
ssh-keygen

# and here we make the connection!
mysql -h 127.0.0.1 -P 3307 -u root -p some_db_on_source_server



SELECT pk, c1
FROM
(
SELECT t1.pk, t1.c1
FROM t1
UNION ALL
SELECT t2.pk, t2.c1
FROM t2
) t
GROUP BY pk, c1
HAVING COUNT(*) = 1
ORDER BY pk


http://jsfiddle.net/FhUwn/392/

To install Arial just simply copy it from windows or anywhere.

arial.ttf
arialbd.ttf

to

/usr/share/fonts

Create dir truetype there and drop those files there.
That works at least on Ubuntu and CentOS

Backup

mysqldump --routines -u root -p --databases db1 db2 db3 | gzip > /var/www/backups/mysql/databases.sql.gz # multiple db using gzip
mysqldump --routines -u root -p --databases db1 db2 db3 | bzip2 > /var/www/backups/mysql/databases.sql.bz2 # multiple db using bz2

mysqldump --routines -u root -p db1 | gzip > /var/www/backups/mysql/db1.sql.bz2 # single db using gzip
mysqldump --routines -u root -p db1 | bzip2 > /var/www/backups/mysql/db1.sql.bz2 # single db using bz2


Restore

bunzip2 < db1.sql.bz2 | mysql -u root -p db1
zcat db1.sql.gz | mysql -u root -p db1


Same goes for multiple DBs just add one or more DB to restore at the end of the command, or leave blank to restore all.