11-24-2015
Ok guys I managed to do all in this way and It is all working with a crontab schedule.
#!/bin/bash
START=`echo $1 | tr -d _`;
TABLE_NAME=M"`date --date="$START" +%Y%m%d`";
echo "Tabella del mese: "$TABLE_NAME;
if [ -f "/var/lib/mysql/database_name/"$TABLE_NAME".frm" ]
then echo "Tabella esistente: OK"
else
echo "Tabella non esistente, la creo";
SQL="create table "$TABLE_NAME"
(WHSSID int not null,
Seriale int not null,
DataOra datetime,
Chiamante text,
Chiamato text,
Prefisso_num_chiamato int,
Descr_prefisso_chiamato varchar(50),
Durata_secondi int,
Costo_conversazione text,
Chiamata_urb_extraurb int,
Chiamata_voce_dati int,
Chiamata_intratwt int,
Prefisso_carrier_destinazione int);";
echo $SQL > /tmp/sql;
mysql -D database_name -u database_name -p_database_password < /tmp/sql;
fi
FILE="ftp://ftp_user:ftp_pass@host/go/directory/0000060468$(date -d-0day +%Y%m%d)N001.Zip";
wget -qq $FILE -P /tmp;
unzip -qq -o -u /tmp/0000060468$(date -d-0day +%Y%m%d)N001.Zip -d /tmp;
SQL="load data local infile '/tmp/0000060468$(date -d-0day +%Y%m%d)N001.CDR' INTO TABLE $TABLE_NAME
FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n'";
echo $SQL > /tmp/sql;
mysql -u database_name -pdatabase_password --local-infile database_name < /tmp/sql;
rm -rf /tmp/*
exit
Last edited by virtus96; 11-26-2015 at 04:26 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file --> file1.txt
i need to copy this file to another server using FTP....the 2 servers are server1 and server2..may i know how to write a script that can do this?
thanks in advance! Im a newbie to this... (4 Replies)
Discussion started by: forevercalz
4 Replies
2. Shell Programming and Scripting
Hello All,
Hope u r doing fine.
I'm writing a shell script to ftp the latest file having pericular convention as 'ULTI_15072007043205.txt' on daily basis.
Now the date & timing of the file geleration isnt constant, so the file name daily varies as per the date & timing of generation.
Can anyone... (7 Replies)
Discussion started by: im_new
7 Replies
3. UNIX for Dummies Questions & Answers
Hi,
i have multile JAMA01.DAT.* files in my ftp.
how can i get the latest file in from the ftp by executing the script :rolleyes:?
Regards,
Arun S (3 Replies)
Discussion started by: arunavlp
3 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I would like an FTP command or series of commands to get only the latest file. Is that possible?
Thanks in advance. (2 Replies)
Discussion started by: laiko
2 Replies
5. Shell Programming and Scripting
Hi
Can any one help me for script. I need a script and this script has to execute daily to move the files.
FTP from one server to another server
EX: Sep 10 06:24 abc.txt
Sep 11 06.56 abc.txt
Sep 12 08.23 abc.txt
these files are located at a/b/c/e/f in 123 server and copy... (0 Replies)
Discussion started by: mahantysk
0 Replies
6. Shell Programming and Scripting
Hello ,
My requirement is as follows:
I want to connect to a remote FTP server using FTP and then get the latest file from server location
can u pls share code snippet for this ?
Regards,
Suresh (4 Replies)
Discussion started by: sureshg_sampat
4 Replies
7. Shell Programming and Scripting
How to FTP the latest file, based on date, from a remote server through a shell script?
I have four files to be FTP'ed from remote server.
They are of the following format.
build1_runtime_mmddyyyy.txt
build2_runtime_mmddyyyy.txt
build3_runtime_mmddyyyy.txt
buifile_count_mmddyyyy.txt
... (9 Replies)
Discussion started by: imran_affu
9 Replies
8. Shell Programming and Scripting
Hello,
I have a script that finds the latest version of a file in a folder on my Minecraft server. I'm trying to come up with something that will then FTP that file over to my fileserver.
Here's what I have that finds the newest file:
find /home/mc/archive/sbhouse -type f -mtime +45 -exec... (7 Replies)
Discussion started by: nbsparks
7 Replies
9. Shell Programming and Scripting
Hello this is my first post in this forum , I dont want to be unhappy..
I am writing one script but facing difficulty to find the latest file with some new pattern
My requirement is
1. The file is coming like "ABCD-23220140303" at FTP server once in a week.
2. script will run on daily... (3 Replies)
Discussion started by: ajju
3 Replies
10. Shell Programming and Scripting
Hi,
I want to create a script that parses the content of a file (on each line there is a filename with full path containing the latest fiels created on that day) and uploads every file to a ftp location.
Any elegant way to do it ? (4 Replies)
Discussion started by: liviusbr
4 Replies
LEARN ABOUT PHP
mysql_db_query
MYSQL_DB_QUERY(3) 1 MYSQL_DB_QUERY(3)
mysql_db_query - Selects a database and executes a query on it
SYNOPSIS
Warning
This function was deprecated in PHP 5.3.0, and will be removed in the future, along with the entirety of the original MySQL exten-
sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more
information. Alternatives to this function include:
omysqli_select_db(3) then the query
o PDO::__construct
resource mysql_db_query (string $database, string $query, [resource $link_identifier = NULL])
DESCRIPTION
mysql_db_query(3) selects a database, and executes a query on it.
o $database
- The name of the database that will be selected.
o $query
- The MySQL query. Data inside the query should be properly escaped.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns a positive MySQL result resource to the query result, or FALSE on error. The function also returns TRUE/ FALSE for INSERT/ UPDATE/
DELETE queries to indicate success/failure.
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.3.0 | |
| | |
| | This function now throws an E_DEPRECATED notice. |
| | |
+--------+---------------------------------------------------+
Example #1
mysql_db_query(3) alternative example
<?php
if (!$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')) {
echo 'Could not connect to mysql';
exit;
}
if (!mysql_select_db('mysql_dbname', $link)) {
echo 'Could not select database';
exit;
}
$sql = 'SELECT foo FROM bar WHERE id = 42';
$result = mysql_query($sql, $link);
if (!$result) {
echo "DB Error, could not query the database
";
echo 'MySQL Error: ' . mysql_error();
exit;
}
while ($row = mysql_fetch_assoc($result)) {
echo $row['foo'];
}
mysql_free_result($result);
?>
Note
Be aware that this function does NOT switch back to the database you were connected before. In other words, you can't use this
function to temporarily run a sql query on another database, you would have to manually switch back. Users are strongly encouraged
to use the database.table syntax in their sql queries or mysql_select_db(3) instead of this function.
mysql_query(3), mysql_select_db(3).
PHP Documentation Group MYSQL_DB_QUERY(3)