How to run mysql client command async in bash?

Asked May 03 '23 at 07:21

Active May 03 '23 at 07:33

Viewed 40 times

Is it possible to run a mysql command async in bash? I tried the & operator at the end, but his causes the process to hang and not quit when the select finished.

Example:

export MYSQL_PWD=rootpw; mysql --user=root --database=my_table -e "SELECT 1" &

Running this command succeeds immediately without the &. And with the & operator, it hangs and never exits. Why?

My goal is to trigger a long running table truncate (and other cleanup commands) while another aggregation process should already start before the truncate finished.

edited May 03 '23 at 07:33

asked May 03 '23 at 07:21

membersound

81,582
193
585
1,120

What is your business purpose to do it? Can CLI command 'screen' help you? – Eugene Kaurov May 03 '23 at 07:31
Added goal above.. – membersound May 03 '23 at 07:33
do you wish to run the above command on CLI or inside a script ? – mrrobot.viewsource May 03 '23 at 09:00
It should run in context of a larger existing bash script. – membersound May 03 '23 at 09:15
Are you sure you are truncating and not deleting? Tuncate is a DDL statement that drops and recreates an existing table. – rabbit May 03 '23 at 12:50

How to run mysql client command async in bash?

0 Answers0