How to Update the database Post: 100090

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script: want to insert values in database when update script runs

Hi , I am new to linux and also also to shell scripting. I have one shell script which unpacks .tgz file and install software on machine. When this script runs I want to insert id,filename,description(which will be in readme file),log(which will be in log file) and name of unpacked folder...

2. Shell Programming and Scripting

Dynamic update loop query on Sybase database

Hello Guys, I'm new to Shell scripting, and i need someone to help me with this issue: I'm trying to do a dynamic update query on Sysbase database table using shell script. Lets say, the Update query is "update Table set id=X" , where X is dynamic value for the loop index. If the loop is...

3. UNIX and Linux Applications

Edit/update an /etc/group database entry (c/c++)

Hello I'm writing a program for managing accounts and groups in a linux system. My problem is how to update the members of a group in the /etc/group file,if i have to add/remove those members. total 3 variables for adding some new members to the group : char **oldmembers=grp->gr_mem; ...

4. Shell Programming and Scripting

rebuild/update fuppes database if files are added/removed from directory

The title says it all. I have a upnp server running fuppes that is connected to my xbox360. In order to see the files on the xbox360 i have to manually update and rebuild the database anytime i add or remove files. I have tried cron jobs to do it every 20 min which works, but if I am streaming...

5. Shell Programming and Scripting

download an html file via wget and pass it to mysql and update a database

CAN I download an html file via wget and pass it to mysql and update a database field?

6. Red Hat

How to update rpm database regarding removed file of a package?

For Suppose, I have installed a package having files file1, file2 and file3. After installation, I removed the file "file3". But "rpm -qf file3" is giving the package name, even file3 was not there. And also "rpm -ql package" is also displaying all 3 files. How can i update rpm database about...

7. UNIX for Dummies Questions & Answers

Using symbolic link for database MySQL in CentOS, not update sizing

I have no idea what I should set the topic here ==' This is my story, please you there kindly help me I'm quite newbie for this. ================================== My host server is CentOS, I spared 9.9GB for /var path that used by MySQL and...It's full because of heavy load traffic, then...

8. Shell Programming and Scripting

Update a database table in a for loop

Im trying to update an informix database table for each occurance of a head_barcode in a file called mw within a for loop please see below - cant get the syntax correct. any help please? for a in `cat /tmp/mw` do sql image - << STOP > /dev/null 2>&1 update doc_table set status =...

LEARN ABOUT DEBIAN

mysql_import_combined_log2

mysql_import_combined_log.pl(1) 			      General Commands Manual				   mysql_import_combined_log.pl(1)

NAME

       mysql_import_combined_log.pl - Imports an Apache combined log into a MySQL database.

SYNOPSIS

       mysql_import_combined_log.pl -d <database name> -t <table name> [-h <host name>] [-u <user name>] [-p <password>] [-f <filename>]

OPTIONS

       --host|-h <host name>

	      The host to connect to. Default is localhost.

       --database|-d <database name>

	      The database to use. Required.

       --username|-u <username>

	      The user to connect as.

       --password|-p <password>

	      The user's password.

       --table|-t <table name>

	      The name of the table in which to insert data.

       --logfile|-f <file name>

	      The file to read from. If not given, data is read from stdin.

       --help|-?

	      Print out this help message.

       --version

	      Print out the version of this software.

AUTHOR

       Aaron Jenson

       Updated to work under Perl 5.6.1 by Edward Rudd

MAN PAGE CREATED BY

       Michael A. Toth <lirul.lists@gmail.com> - based on content of script

COMMENTS

       This man page was written using xml2man (1) by the same author.

Manuals 							       User					   mysql_import_combined_log.pl(1)