Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Cron to Auto Insert SQL to DB

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cron to Auto Insert SQL to DB
# 1  
Old 06-16-2008
Cron to Auto Insert SQL to DB
Hi People..
This is driving me mad.

I have approx 100 files received daily, normally in 5 min intervals in the format of..

******-logfile.sql

These are auto uploaded to a folder on server called filelist

The format of each file is as follows.

DELETE FROM `webuserdata` WHERE `NickName` = "OkiesPlace";
Insert into webuserdata (NickName, FileStatus, Correspondent, Period, FileName, Series, Files) values ('OkiesPlace','Sent','Enforcer','May 2008','CB30001-05 - Spears Britney - From The Bottom Of My Broken Heart.zip','CB','1');

These could each have between 1 and 3000 Insert Lines.

Can someone please tell me how, when the file is received to folder filelist
these files should be auto inserted to the database.

I assume somewhere I have to make a file that includes the connection codes to DB.

But what that is and where I put is a total loss.

Thanks for any help

Regards
Keith
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

From sql Insert Query to XML format

Hi How do I translate Let say Cat inserts.sql gives Insert into PM9_TAXATION_ROUNDING (STATE_GECODE, TAX_TYPE, TAX_AUTHORITY, SYS_CREATION_DATE, SYS_UPDATE_DATE, APPLICATION_ID, DL_SERVICE_CODE, ROUNDING_METHOD) Values ('xx', 'xx', 'x', TO_DATE('10/26/2012 13:01:20',... (3 Replies)
Discussion started by: anuj87in
3 Replies

2. Programming

[SQL] Insert content file to mysql

dear all, i want to insert string in file to mysql i just want how to do that cause i am poor in sql languages ... so this file like this DATA.txt doni|student|westjava|123412|lombok| iwan|student|westjava|1234412|utankayu| rio|student|westjava|12342|cempedak| so i want insert DATA.txt to... (2 Replies)
Discussion started by: zvtral
2 Replies

3. Shell Programming and Scripting

convert file into sql insert stmt

My file is now cleaned, sanitized & prepped: 07/07/2008 21:18:51 Installation 52016 complete *BUT NOTHING CHANGED* 07/21/2008 15:28:15 Removal 52016 complete 07/21/2008 15:34:15 Removal 55856 complete 12/08/2009 19:30:40 Installation 62323 complete 12/08/2009 19:39:06 Installation ... (6 Replies)
Discussion started by: dba_frog
6 Replies

4. Emergency UNIX and Linux Support

Insert data into sql queries from a file

Hello friends, I need to insert data from a file to another. I need this to form an sql query file which will consist of 50.000 INSERT INTO sentences. my sql query file will consist of 50.000 times the below line consecutively: insert into subscriber... (6 Replies)
Discussion started by: EAGL€
6 Replies

5. Programming

SQL : Fine tune Insert by query

i would like to know how can i fine tune the following query since the cost of the query is too high .. insert into temp temp_1 select a,b,c,d from xxxx .. database used is IDS.. (1 Reply)
Discussion started by: expert
1 Replies

6. Shell Programming and Scripting

Auto enable/disable cron job

Hi all, Does anyone know if it is possible to enable/disable a cron job within a script? I currently have a cron job which runs every minute but now it seems that sometimes I would like to turn this job off if a condition is met. I would then like to re-enable the job at a later date. ... (5 Replies)
Discussion started by: pxy2d1
5 Replies

7. Solaris

Cron Job -- auto start process when it dies

I would like to setup a Cron job to check weather X process is running or not. if it is not running then start that X process with a log message.... can any one help writing a script? thanks (3 Replies)
Discussion started by: chandravadrevu
3 Replies

8. Web Development

SQL Select inside Insert

I have following. . . . $userid = 2 . $query = "select username from users where userid = ".$userid.";"; . $username = $line; $data="Some Data Here"; . $query = "insert into logger (username, data) valuse ($username, $data);"; . I would like to not have 2 database calls. (3 Replies)
Discussion started by: Ikon
3 Replies

9. UNIX for Dummies Questions & Answers

SQL Loader Auto Number Generation

Hi all, I have a doubt in SQL Loader. We have SEQUENCE function in SQL Loader or can create Sequence in Oracle database for generating a number sequence for a column while loading data using SQL Loader into table or multiple tables. My requirment is this. For the first run in SQL... (2 Replies)
Discussion started by: vinoth_kumar
2 Replies

10. Shell Programming and Scripting

sql insert command

Hi, sqlplus -s / <<EOF > /dev/null insert into table1 (a1, a2, a3) values ('a',1,'b'); commit; EOF in the above code can i pass the values to the insert command from shell script like this: insert into table1 (a1, a2, a3) values ('$a',$b,'$c'); If yes, how is it passed?? Any... (2 Replies)
Discussion started by: abey
2 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

approx-gc

APPROX-GC(8)						      System Manager's Manual						      APPROX-GC(8)

NAME

       approx-gc - garbage-collect the cache of Debian archive files

SYNOPSIS

       approx-gc [OPTION]...

DESCRIPTION

       approx-gc  scans  the  cache created by approx(8) and finds files that are corrupted or no longer needed.  With no options specified, these
       files are listed on standard output and removed from the cache.

       A corrupted file is one whose size or checksum does not match the value specified in the Packages or Sources file.

       An unneeded file is one that is not referenced from any distribution's Packages or Sources file.

       approx-gc may take several minutes to finish.

OPTIONS

       -c file, --config file
	      Specify an additional configuration file.  May be used multiple times.

       -f, --fast
	      Don't perform checksum validation.

       -k, --keep, -s, --simulate
	      Don't remove files from the cache.

       -q, --quiet
	      Don't print file names.

       -v, --verbose
	      Print the reason for removal of each file.

EXAMPLES

       To remove all unneeded or corrupted files from the cache:

	      approx-gc --quiet

       This is run as a weekly cron(8) job.

       To list the files that would be removed from the cache, without actually doing so:

	      approx-gc --keep

FILES

       /etc/approx/approx.conf
	      Configuration file for approx and related programs.

       /var/cache/approx
	      Default cache directory for archive files.

SEE ALSO

       approx.conf(5), approx(8), cron(8)

AUTHOR

       Eric Cooper <ecc@cmu.edu>

								     May 2011							      APPROX-GC(8)