Riccardo Riva

Posts Tagged ‘backup’

The following is a list of MySQL useful commands.

# To setup root password (first execution)
mysqladmin -u root password 'new_password'

# To login to MySQL
mysql -u root -p

# To create a database
create database dbname;

# To change database
use dbname;

# To create a user and assign to it permission to database
# Grant permission only from localhost connections
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

# Grant permission on all connections
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

# Manage MySQL export
# Copy all db1 content to /backup-db/db1 folder
mysqlhotcopy db1 /backup-db/db1

# Create a DB dump to a file
mysqldump db1 > db1_dump_db.sql -u root -p

Hope this help

Bye
Riccardo

Bookmark It

I’m using this script in a lot of Linux Server, especially some file server with a little ERP software written in COBOL with all files in /home/erp.
I’m saving all /home and /etc to have a full backup for disaster recovery purpose.

This scrit will do the following :

- Define variables
- Define DATE
- Create a compress archive of /home and /etc
- Rewind the TAPE
- Write all the data on TAPE
- Verify the TAPE
- Eject the TAPE

Obviously all the output of the above operations will be redirected to a log file fr diagnostic purpose.

- Mail all logged operations to the Server admin

The only prerequisites for let all works is “mail” packages installed on your system and a local mail server configured for routing mail to your “Server Admin” email address, I’m using Postfix, but you coul’d use whatever you want (eg. QMail or EXIM).
Read the rest of this entry »

Bookmark It

This post will show a backup script used to create copies for a server running Oracle 10.2, some application server like FourJS and JBoss and some custom application written in java.

The backup process is divided in some parts :
- Variable declaration and export
- Oracle export and compress
- Data folder export and compress
- Application Server export and compress
- Tape writing of all compress file
- Tape checking
- Mail logging

This post assume you have the following enviroments, if you have something different you should only change variable declaration and comment some lines to have this script works.

- Oracle SID : DB01
- Oracle main folder : /oracle/product/10.2/db_1
- Oracle user/password : system/system
- DATA main folder to backup : /data
- APPSERVER main Folder : /appsrv
- Main backup folder : /data/backup

- Tape device : /dev/st0
Read the rest of this entry »

Bookmark It

I toke me a long time on getting this to work right because of a number
of things like the firewall in ESX 3 and what BE Linux agent to use..
so that is why I have made this webpage so you can save time on this
when you setup a new ESX 3 server and don’t have the time to fight with
this.

Remote Agent for Linux and UNIX Servers (RALUS) 10.x

First the RALUS 10.x does not work on ESX because it can not see the
VMFS file system and Veritas will not fix this before next version
because it do not understand “links” in the file system.. so don’t use
time on.

you can see this Veritas
href=”http://support.veritas.com/docs/278671″>KB
id=”DOCUMENT_ID”>278671 about it and
her is what they write

Backup Exec UNIX Agent 5.0 revision 5.046

This is the Linux agent to use as it works and it can be download on
this Veritas
href=”http://support.veritas.com/docs/262592″>KB262592
or if you have Backup Exec 9.1 installed on your Windows server then is
found in a subfolder of the app.

Backup Exec on remote Windows server

This howto and the “Backup Exec UNIX Agent 5.0 revision 5.046″ is
working with Backup Exec 9.1, 10.x and 10D for Windows
Here is how to install it on the VMware ESX 3.0 and setup
Backup Exec for Windows

1. Download the linux agent software to a folder on the ESX 3.0 server

2. Login as Root on the ESX server

3. Change to folder and verify the TAR file is there

5. Starting the Installation

6. Select OS as Linux 2.4 (number 5)

7. Type Y to install in the default folder

8. Hit Enter to continue

9. Type in the host and domain name of this ESX server

10. Select N (can be changed later if you like)

11. No matter how many netcards you have select Y two times and enter
the IP number of the ESX COS IP

12. Select the / to be export and then wait with other paths as we type
them into the config file later!

13. Enter the IP number of the remote Backup Exec 9.1, 10.x or 10D
server that you like to backup this server.

14. Enter 30 as the advertisement time, note that if you select another
value there is maybe a regkey on the windows server you need to change
also but Veritas write about it in the documentation.

15. Just select 1 and go on

16. Now the software is installed and pre config

17. Goto the remote Backup Exec server and into the options, then
change the settings to be like this.

18. Now on the ESX server again, Config the ESX firewall to allow
Backup exec Linux agent to talk with the remote backup exec server

19. Config the ESX firewall to allow the remote Backup exec server to
talk with the agent on the ESX server.

20. Reload the firewall config

21. open and edit the agent config file

22. Change the config file to match your setup and write the file to
disk

21. Restart the Backup Exec agent so it read the new config

22. Now go to the remote backup server and make a test backup job where
you select some folders to backup with a lot of data so you can see
that it is stabile.

23. Monitor it is backup the file and the speed is what you expect it
to be, I have a LTO3 autoloader and the network is 1gbit and I can see
the network traffic is around 250mbit between the server so that is
just fine.

24. Now monitor the verify, note the high speed is because it just
verifying checksums and there for fast, the network is also note
showing any trafic at all.

Now Backup exec Linux agent is installed on the ESX 3.0 server
and works well

Bookmark It

Today I had to install an ArcServer Unix agent on a brand new Linux system, and as any times i can’t find an init script that allow to start/stop/restart or see the agent status.

Google wasn’t my friend because I was without internet access so I’ve decided to write it by myself.

follow the Linux Init Script for ArcServe Unix Agent :

#! /bin/sh
#
# Author: Riccardo Riva
#

# System startup script for the inet daemon
#
### BEGIN INIT INFO
# Provides: uagent
# Default-Start: 2 3 5
# Default-Stop: 0 1 6
# Description: Start UAgent daemon.
### END INIT INFO

if [ -e /etc/rc.config ]; then
. /etc/rc.config
fi

if [ -e /etc/rc.status ]; then
. /etc/rc.status
fi

# Determine the base and follow a runlevel link name.
base=${0##*/}
link=${base#*[SK][0-9][0-9]}

uagent_bin=/opt/uagent/uagent
return=$rc_done

# Reset status of this service.
rc_reset

# See how we were called.
case “$1″ in
start)
echo -n “Starting Uagent daemon: ”
$uagent_bin start || return=$rc_failed
echo -e “$return”
;;
stop)
echo -n “Stopping UAgent daemon: ”
$uagent_bin stop
sleep 2
$uagent_bin stop || return=$rc_failed
echo -e “$return”
sleep 2
;;
restart)
echo -n “Stopping UAgent daemon: ”
$uagent_bin stop
sleep 2
$uagent_bin stop || return=$rc_failed
echo -e “$return”
sleep 2
echo -n “Starting Uagent daemon: ”
$uagent_bin start || return=$rc_failed
echo -e “$return”
;;
status)
echo -n “Checking for UAgent daemon: ”
$uagent_bin status && echo OK || echo No process
;;
*)
echo “Usage: $0 {start|stop|status}”
exit 1
esac

test “$return” = “$rc_done” || exit 1
exit 0

 Print This Post

Bookmark It