• The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    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. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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