• Dear Pleskians! The Plesk Forum will be undergoing scheduled maintenance on Monday, 7th of July, at 9:00 AM UTC. The expected maintenance window is 2 hours.
    Thank you in advance for your patience and understanding on the matter.

Question SELECT COMMAND IN MYSQL QUERY FROM SHELL SCRIPT

clubedemidia

New Pleskian
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?
 
${} 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.
 
Back
Top