Question SELECT COMMAND IN MYSQL QUERY FROM SHELL SCRIPT

[clubedemidia]

Server operating system version

AlmaLinux 8.10 (Cerulean Leopard)

Plesk version and microupdate number

Plesk Obsidian 18.0.62 Update #2

I need do clean up and optimize a table from one of my customers databases.
It is a LOG table and i'm trying to create a way to automate the process.

So i'm trying to create a shell script that runs with the SQL command, but it isn't working.
The command i'm using is:

--------------------------
# SETTING VIRIABLES
mysql_user="admin"
mysql_password="`cat /etc/psa/.psa.shadow `"
mysql_database="xxxxxxxxxxxx"

# COMMAND AND SQL
mysql --user=${mysql_user} --password=${mysql_password} --database=${mysql_database} "DELETE FROM name-of-the-table WHERE created_at < '2024-07-01 00:00:00';"

# QUIT
quit
-----------------

The return I'm getting is:
line 6: $'\r': command not found
line 7: $'\r': command not found
line 9: quit: command not found

Can anyone help me?

 

[mow]

${} does not do what you think it does. Lose the {}.
And it's 'exit', but you don't actually need that because the script ends anyway.