I have finished testing rsync and it works like a charm. As promised, below is the finished shell script.
Code:
#!/bin/sh
# *********************************************************************
# *
# * Script Name : sysbck
# *
# * Description : Performs system backup to a remote NSF share
# *
# *********************************************************************
# * Copyright 2015-20xx by Trolley Computers
# *********************************************************************
# *********************************************************************
# * V A R I A B L E S
# *********************************************************************
# *********************************************************************
# * F U N C T I O N S
# *********************************************************************
# *********************************************************************
# * E R R O R H A N D L I N G
# *********************************************************************
# *********************************************************************
# * M A I N S C R I P T
# *********************************************************************
echo ==============================
date
echo ==============================
#
# Mount Remote NSF Share
#
echo ""
echo "Mount Remote NSF Share"
echo ""
/etc/mount /mnt/provmed
sleep 3
df -v
echo ""
echo ""
#
# Backup Files
#
echo ""
echo "Backup Files..."
echo ""
/usr/local/bin/rsync -vruog --delete /u2/* /mnt/provmed/.
echo ""
echo ""
#
# Un-Mount Remote NSF Share
#
cd
echo ""
echo "Un-Mount Remote NSF Share"
echo ""
/etc/umount /mnt/provmed
echo ==============================
date
echo ==============================
# *********************************************************************
# * E X I T S C R I P T
# *********************************************************************
I have been tasked with getting an AIX 4.3.3 box to backup to a NAS applicance device which provides NFS service. It is an intermediary repository so that other tools can transport the resulting backup file to another NAS Applicance at a remote site on a secondary frame connection.
Anyone have... (10 Replies)
Dear All
I am using cat command for concatenating multiple files. Some time i also use append command when there are few files.
Is there faster way of concatenating multiple files(60 to 70 files) each of
156 MB or less/more.:)
Thanx (1 Reply)
Hi guys,
I have a redhat laptop and a sun solaris 8 server networked together
I created an nfs share on the sun server and backed up an image of the Redhat laptop to it.
The Hard disk size of the laptop is 40Gb but I have about 38Gb free space on the sun server. So I compressed the image... (9 Replies)
Hi All,
I have some 80,000 files in a directory which I need to rename. Below is the command which I am currently running and it seems, it is taking fore ever to run this command. This command seems too slow. Is there any way to speed up the command. I have have GNU Parallel installed on my... (6 Replies)
Hi Everyone,
we are running rsync with --backup mode, Are there any rsync options to remove backup folders on successful deployment?
Thanks in adv. (0 Replies)
Hello,
I was wondering if anyone knows a faster way to search and compare strings and dates from 2 files?
I'm currently using "for loop" but seems sluggish as i have to cycle through 10 directories with 10 files each containing thousands of lines.
Given:
-10 directories
-10 files... (4 Replies)
Good evening
Im new at unix shell scripting and im planning to script a shell that removes headers for about 120 files in a directory and each file contains about 200000
lines in average.
i know i will loop files to process each one and ive found in this great forum different solutions... (5 Replies)
We are taking backup of our application data(cobol file system, AIX/unix) before and after EOD job runs. The data size is approximately 260 GB in biggest branch. To reduce the backup time, 5 parallel execution is scheduled through control-m which backups up the files in 5 different *.gz. The job... (2 Replies)
We are taking backup of our application data(cobol file system, AIX/unix) before and after EOD job runs. The data size is approximately 260 GB in biggest branch. To reduce the backup time, 5 parallel execution is scheduled through control-m which backups up the files in 5 different *.gz. The job... (8 Replies)
I have a very big input file <inputFile1.txt> which has list of mobile no
inputFile1.txt
3434343
3434323
0970978
85233
... around 1 million records
i have another file as inputFile2.txt which has some log detail big file
inputFile2.txt
afjhjdhfkjdhfkd df h8983 3434343 | 3483 | myout1 |... (3 Replies)
Discussion started by: reldb
3 Replies
LEARN ABOUT PHP
mssql_num_fields
MSSQL_NUM_FIELDS(3)MSSQL_NUM_FIELDS(3)mssql_num_fields - Gets the number of fields in resultSYNOPSIS
int mssql_num_fields (resource $result)
DESCRIPTION mssql_num_fields(3) returns the number of fields in a result set.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
RETURN VALUES
Returns the number of fields, as an integer.
EXAMPLES
Example #1
mssql_num_fields(3) example
<?php
// Connect to MSSQL and select the database
$link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php', $link);
// Select some data from our database
$data = mssql_query('SELECT [name], [age] FROM [php].[dbo].[persons]');
// Construct a table
echo '<table border="1">';
$header = false;
// Iterate through returned results
while ($row = mssql_fetch_array($data)) {
// Build the table header
if (!$header) {
echo '<thead>';
echo '<tr>';
for ($i = 1; ($i + 1) <= mssql_num_fields($data); ++$i) {
echo '<td>' . ucfirst($row[$i]) . '</td>';
}
echo '</tr>';
echo '</thead>';
echo '<tbody>';
$header = true;
}
// Build the row
echo '<tr>';
foreach($row as $value) {
echo '<td>' . $value . '</td>';
}
echo '</tr>';
}
// Close table
echo '</tbody>';
echo '</table>';
// Clean up
mssql_free_result($data);
mssql_close($link);
?>
SEE ALSO mssql_query(3), mssql_fetch_field(3), mssql_num_rows(3).
PHP Documentation Group MSSQL_NUM_FIELDS(3)