www.manolo-lopez.com

Google street car in Valencia

manolo | 28 Junio, 2008 22:00

Hace unos dias , iva por san Antonio de Benageber y me encontre en una esquina , el coche de google street.

No se si en ese momento estaba grabando , y si va a salir , pero lo que si estoy seguro es en donde lo vi, cuando salga lo vere.

La foto es mala pero lo unico que tenia era la camara del movil !

google street car en Valencia

How to make automated mysql backups wlth automysqlbackup and crond

manolo | 10 Junio, 2008 20:45

I insert in my slackware box under /etc/cron.daily the automysqlbackup script to backup mysqldata , just in case of crash / destruction of the database.

It uses the mysqldump feature.

The scrip is easy to install and configure. You can Backup mutiple MySQL databases with one script.

Just download the and edit with vi or pico the following lines

# Username to access the MySQL server e.g. dbuser
USERNAME=morgan

# Username to access the MySQL server e.g. password
PASSWORD=yourpassword

# Host name (or IP address) of MySQL server e.g localhost
DBHOST=localhost

# List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3"
DBNAMES="database1 database2"

# Backup directory location e.g /backups
BACKUPDIR="/var/backups_mysql"

Can also e-mail the backup log to any specified e-mail address and Automatically compress , for saving space.

I received this mail from this scrip to my gmail adress:

AutoMySQLBackup VER 2.5
http://sourceforge.net/projects/automysqlbackup/

Backup of Database Server - server
==============================

========================================
Backup Start Time Tue Jun 10 04:40:01 CEST 2008
======================================================================
Daily Backup of Database ( database1 )
Rotating last weeks Backup...

Backup Information for /var/backups_mysql/daily/database1_2008-06-10_04h40m.Tuesday.sql
compressed uncompressed ratio uncompressed_name
415086 2546924 83.7% /var/backups_mysql/daily/database1_2008-06-10_04h40m.Tuesday.sql
----------------------------------------------------------------------
Daily Backup of Database ( gallery2 )
Rotating last weeks Backup...

Backup Information for /var/backups_mysql/daily/database2_2008-06-10_04h40m.Tuesday.sql
compressed uncompressed ratio uncompressed_name
21494 138014 84.5% /var/backups_mysql/daily/database2_2008-06-10_04h40m.Tuesday.sql
----------------------------------------------------------------------
Backup End Tue Jun 10 04:40:02 CEST 2008
======================================================================
Total disk space used for backup storage..
Size - Location
864K /var/backups_mysql

====================================================================