Backup MySQL dengan MySqlBF

Pada server MySQL, dalam /etc/mysql/my.cnf tukar IP localhost ke IP sebenar server tersebut

#bind-address           = 127.0.0.1
bind-address            = 192.168.1.5

Restart servis MySQL
/etc/init.d/mysql restart

Buatkan user bernama backup untuk backup dari IP 192.168.1.10 dengan kata laluan Do05esk7

mysql -u root -p
grant all on *.* to [email protected]'192.168.1.10' identified by 'Do05esk7';
\q

Sekarang cuba sambungkan MySqlBF dari 192.168.1.10 ke mysql server

login

Tetapkan database yang hendak kita backup dan lokasi simpanannya

setting

Contoh backup yang telah selesai, output pada destinasi dan laporan yang dihantar ke emel

log

output

emel

Nota: Had versi percuma adalah 2 db sahaja

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Pasang Netvault Backup 8.6.3 pada Debian Squeeze

OS: Debian Squeeze 32-bit
IP: 192.168.56.101
Installer: netvault-R2012MAY21-JUNO-LinuxX86Hybrid.tar.gz

Muatnaik pakej installer Netvault Backup ke pelayan Debian
scp netvault-R2012MAY21-JUNO-LinuxX86Hybrid.tar.gz [email protected]:/root

Pasang libxp6 pada pelayan Debian
aptitud -y install libxp6

Ekstrak pakej installer
tar -xvf netvault-R2012MAY21-JUNO-LinuxX86Hybrid.tar.gz
cd netvault/
chmod +x install

Pasang Netvault Backup Server
./install

Jawab soalan seperti berikut:

Select language? [1] :

Have you read and agreed to the terms of the license?
(y = yes, n = no, d = display license) (y n d) [d] : y

Should a client or server version of NetVault be installed? (c s) : s

Where should NetVault be installed? [/usr/netvault] :

Where should NetVault database be installed? [/usr/netvault/db] :

Please enter a NetVault machine name
using A-Z, a-z, _ and 0-9 [debian] :

Please enter the NetVault password for this machine:

Please confirm password:
.
.
.
Installation completed successfully

Perhatikan sama ada proses netvault telah berjalan
ps -ef| grep nv

root      1657     1  0 02:07 pts/0    00:00:00 /usr/netvault/bin/nvpmgr
root      1660  1657  0 02:07 pts/0    00:00:00 nvcmgr 2
root      1668  1657  0 02:07 pts/0    00:00:00 nvnmgr 3
root      1669  1657  0 02:07 pts/0    00:00:00 nvavp 8
root      1670  1657  0 02:07 pts/0    00:00:00 nvlogdaemon 7
root      1671  1657  0 02:07 pts/0    00:00:00 nvstatsmngr 9
root      1673  1657  0 02:07 pts/0    00:00:00 nvrepdbmngr 10
root      1674  1657  0 02:07 pts/0    00:00:00 nvmedmgr 4
root      1675  1657  0 02:07 pts/0    00:00:00 nvsched 5
root      1706  1295  0 02:08 pts/0    00:00:00 grep nv

Cuba akses dari mana-mana desktop Linux atau menggunakan MobaXterm dari desktop Windows
ssh -X [email protected]

Mulakan GUI Netvault Backup
nvgui &

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Nota pemasangan NetVault pada CentOS 5.6

Pakej-pakej yang diperlukan untuk pemasangan NetVault
yum install libXp libXt

Untuk ssh forwarding
yum install xorg-x11-xauth xorg-x11-fonts-base liberation-fonts

Pastikan telah ‘uncomment’ berikut di dalam fail /etc/ssh/sshd_config
X11Forwarding yes
X11DisplayOffset 10
X11UseLocalhost yes

Mulakan semula servis sshd
service sshd restart

Cuba log masuk dengan klien ssh
ssh -Y [email protected]

Cuba mulakan NVGUI
nvgui &

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Nota klien Amanda untuk Linux #1

Walapun boleh set IP untuk point ke pelayan backup amanda dalam /etc/amanda/amanda-client.conf, tapi mesti set sebagai FQDN dalam ~/amanda/.amandahosts

Contoh entri kalau FQDN pelayan adalah backup.domain.com:

backup amandabackup amdump
backup.domain.com amandabackup amdump

Kalau tak guna DNS server, kena set secara manual dalam /etc/hosts seperti berikut kalau IP pelayan adalah 10.10.10.1

10.10.10.1 backup.domain.com backup

Siapa boleh terangkan keanehan ini?

Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)