• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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