• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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