Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Mysql is not working in shell script
Top Forums Shell Programming and Scripting Mysql is not working in shell script Post 303018462 by Jewel on Thursday 7th of June 2018 04:17:23 AM
Old 06-07-2018
Mysql is not working in shell script
Hi Team,

I have created attached script in mysql environment. But there is below error .
can you please suggest .

Error : Unknown table 'processlist' in finformation_schema


Code:
#!/bin/bash
mysql -u $DBUSER -p$DBPASS -e "
select 
-- * 
id
from information_schema.processlist 
where command = 'SLEEP' 
and time > 1 
and host ='localhost'
" | while read id; 
do 
    if [[ "id" == "$id" ]]
    then
        continue
    fi
    echo "kill $id";
    mysql -u $DBUSER -p$DBPASS -e "kill $id";
done

script.txt (331 Bytes) 
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Mysql with shell script

Hi did any books teaching beginner to run mysql using BASH shell? thkx (5 Replies)
Discussion started by: lijiajin
5 Replies

2. Shell Programming and Scripting

executing mysql load statement from shell script

Hi, I have a piece of shell script which will connect to mysql database and execute a load statement(which will load datas in a file to the database table).The code is working and the data is in the tables. Now my requirement is, i need to grab the output from the load statement... (4 Replies)
Discussion started by: DILEEP410
4 Replies

3. Shell Programming and Scripting

Multiple MySql queries in shell script?

Hi guys, i know how to run a single query using mysql embedded in a shell script as follows: `mysql -umyuser -pmypass --host myhost database<<SQL ${query}; quit SQL` However, how would i be able to run several queries within the same connection? The reason for this is i am creating... (3 Replies)
Discussion started by: muay_tb
3 Replies

4. Shell Programming and Scripting

Passing a variable from shell script to mysql query?

I heard this was possible but from my research I haven't been able to figure it out yet. Seems it should be simple enough. Basically from a high level view I'm trying to accomplish... . $X='grep foo blah.log' then 'mysql command SELECT foo FROM bar WHERE ' . $X or something like that. ... (2 Replies)
Discussion started by: kero
2 Replies

5. Shell Programming and Scripting

How to get and process mysql result set in shell script

Hi All, I am in a problem here is the description, Actually in my shell script i am firing a mysql query which returns multiple records and i have to process each record one by one. So could any one please suggest me how to solve my problem? Thanks in Advance Ashok Sharma (4 Replies)
Discussion started by: ashok1979
4 Replies

6. Shell Programming and Scripting

Using a shell script variable in a mysql query using 'LIKE'

Hello. I am writing a simple script that reads a text file and removes records from a mysql database. The items in the text file are of the format: firstname.middle.lastXXX, where XXX is a 3 digit number. The table has an email field that will match the firstname.middle.last. So, I thought I... (1 Reply)
Discussion started by: bricoleur
1 Replies

7. Shell Programming and Scripting

mysql script in a command shell

Hi i`m trying this script to run and i get the following error. Enter your name tman Enter your surname smith -bash: ./500: line 20: unexpected EOF while looking for matching `"' -bash: ./500: line 21: syntax error: unexpected end of file ... (2 Replies)
Discussion started by: mduduzi
2 Replies

8. Shell Programming and Scripting

mysql script in a command shell

Hi can anyone help with my issue here. I new in linux and new in scripting. i was ask to do the following below and i`m getting errors. I managed to create the table and the database. Now i need to add the details in a shell to update the database.... (7 Replies)
Discussion started by: mduduzi
7 Replies

9. Shell Programming and Scripting

Shell script - Download - Mysql replace

Hi, I have a video script. it has embedded Youtube videos. I want replace them downloaded version mp4 videos. this script has a mysql table. I want search "url_flv" field on table a youtube link if has a youtube link I want download it this command. I want extract uniq_id field for file... (2 Replies)
Discussion started by: tara123
2 Replies

10. Shell Programming and Scripting

Cp not working in shell script but running perfectly from shell

Dear All, I have script. Dest="" IFS=' ' for translation in $(echo $MY_MAP) do t1=$(echo $translation | cut -d"=" -f1) t2=$(echo $translation | cut -d"=" -f2| cut -d"," -f1) if then Dest=$UNX/$u_product_path/$u_study_path/$UNXTR/$t2 break; ... (4 Replies)
Discussion started by: yadavricky
4 Replies

LEARN ABOUT DEBIAN

rabbitmq-env.conf

RABBITMQ-ENV.CONF(5)						  RabbitMQ Server					      RABBITMQ-ENV.CONF(5)

NAME

       rabbitmq-env.conf - default settings for RabbitMQ AMQP server

DESCRIPTION

       /etc/rabbitmq/rabbitmq-env.conf contains variable settings that override the defaults built in to the RabbitMQ startup scripts.

       The file is interpreted by the system shell, and so should consist of a sequence of shell environment variable definitions. Normal shell
       syntax is permitted (since the file is sourced using the shell "." operator), including line comments starting with "#".

       In order of preference, the startup scripts get their values from the environment, from /etc/rabbitmq/rabbitmq-env.conf and finally from
       the built-in default values. For example, for the RABBITMQ_NODENAME setting,

       RABBITMQ_NODENAME

       from the environment is checked first. If it is absent or equal to the empty string, then

       NODENAME

       from /etc/rabbitmq/rabbitmq-env.conf is checked. If it is also absent or set equal to the empty string then the default value from the
       startup script is used.

       The variable names in /etc/rabbitmq/rabbitmq-env.conf are always equal to the environment variable names, with the RABBITMQ_ prefix
       removed: RABBITMQ_NODE_PORT from the environment becomes NODE_PORT in the /etc/rabbitmq/rabbitmq-env.conf file, etc.

       # I am a complete /etc/rabbitmq/rabbitmq-env.conf file.
       # Comment lines start with a hash character.
       # This is a /bin/sh script file - use ordinary envt var syntax
       NODENAME=hare

SEE ALSO

       rabbitmq-server(1) rabbitmqctl(1)

EXAMPLES

       # I am a complete /etc/rabbitmq/rabbitmq-env.conf file.
       # Comment lines start with a hash character.
       # This is a /bin/sh script file - use ordinary envt var syntax
       NODENAME=hare

       This is an example of a complete /etc/rabbitmq/rabbitmq-env.conf file that overrides the default Erlang node name from "rabbit" to "hare".

AUTHOR

       The RabbitMQ Team <info@rabbitmq.com>

RabbitMQ Server 						    06/22/2012						      RABBITMQ-ENV.CONF(5)
All times are GMT -4. The time now is 06:34 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy