backup restore mysql sugar crm

backup:

mysqldump -u root -ppassw0rd sugarcrm > \
backup/sugarcrm_11-12-2008-01_dump.sql

mysqldump -u root -ppassw0rd sugarcrm > \ backup/sugarcrm_11-12-2008-02_dump.sql

mysqldump -u root -ppassw0rd --all-databases > \ backup/all-database_11-12-2008-01.sql

mysqldump -u root -ppassw0rd --all-databases > \ backup/all-database_11-12-2008-02.sql

Restore:

mysql -u root -peLaStIx.2oo7 sugarcrm < \ backup/sugarcrm_11-12-2008-02_dump.sql

Remote Access to Mysql

grant select on *.* to 'root'@192.168.100.54 identified by 'eLaStIx.2oo7';
grant update on *.* to 'root'@192.168.100.54 identified by 'eLaStIx.2oo7';
grant create on *.* to 'root'@192.168.100.54 identified by 'eLaStIx.2oo7';
flush privileges;

multi-boot solaris x86

#---------- ADDED BY BOOTADM - DO NOT EDIT ----------
# Solaris 32bits
title Solaris 10 10/08 s10x_u6wos_07b X86 32b
findroot (rootfs0,3,a)
kernel /boot/multiboot kernel/unix
module /platform/i86pc/boot_archive
#---------------------END BOOTADM--------------------
title Solaris 10 10/08 s10x_u6wos_07b X86 64b
findroot (rootfs0,3,a)
kernel /platform/i86pc/multiboot
module /platform/i86pc/boot_archive
#---------------------END BOOTADM--------------------
#---------- ADDED BY BOOTADM - DO NOT EDIT ----------
title Solaris failsafe
findroot (rootfs0,3,a)
kernel /boot/multiboot kernel/unix -s
module /boot/x86.miniroot-safe
#---------------------END BOOTADM--------------------

title Ubuntu 8.10, kernel 2.6.27-7-generic
root (hd0,0)
kernel /boot/vmlinuz-2.6.27-7-generic root=/dev/sda1 ro quiet splash
initrd /boot/initrd.img-2.6.27-7-generic

Procedure to add a swap file

a) Login as the root user

b) Type following command to create 512MB swap file (1024 * 512MB = 524288 block size):
# dd if=/dev/zero of=/swapfile1 bs=1024 count=524288

c) Set up a Linux swap area:
# mkswap /swapfile1

d) Activate /swapfile1 swap space immediately:
# swapon /swapfile1

e) To activate /swapfile1 after Linux system reboot, add entry to /etc/fstab file. Open this file using text editor such as vi:
# vi /etc/fstab

Append following line:
/swapfile1 swap swap defaults 0 0

So next time Linux comes up after reboot, it enables the new swap file for you automatically.

g) How do I verify swap is activated or not?
Simply use free command:
$ free -m

profile solaris 10

PATH=$PATH:/usr/sbin:/opt/csw/bin:/usr/sfw/bin:/usr/ccs/bin:/usr/local/sbin:/usr/local/bin
LIBPATH=$LIBPATH:/opt/csw/lib:/usr/sfw/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$LIBPATH
export PATH LD_LIBRARY_PATH LIBPATH

zone clone

# Bajar la zona que se desea clonar
zlogin CT1NSZSOPVA003 init 0

# Validar que la zona ya esta en shutdown
zoneadm list -cv

# Exportart la configuracion de la zona y salvarla con el nombre de la nueva zona que se desea crear
zonecfg -z CT1NSZSOPVA003 export -f /root/cfg/CT1LOGZSOPVA001.cfg

# Modificar parametros con el zonepath, Direcciones IP y demas que se requieran en la nueva zona.
vi /root/cfg/CT1LOGZSOPVA001.cfg

# Crear la nueva zona apartir de archivo de configuracion modificado.
zonecfg -z CT1LOGZSOPVA001 -f /root/cfg/CT1LOGZSOPVA001.cfg

# Clonar la zona
zoneadm -z CT1LOGZSOPVA001 clone CT1NSZSOPVA003

# Validar que la nueva zona esta en estado "Installed"
zoneadm list -cv

# Hacer boot de la nueva zona
zoneadm -z CT1LOGZSOPVA001 boot

# Validar que la nueva zona esta running
zoneadm list -cv

# Hacer la configuracion Inicial de la zona.
zlogin -C CT1LOGZSOPVA001

MP3 in Ubuntu

sudo apt-get install audacious