3 Jul
2023
3 Jul
'23
12:48 p.m.
On 03.07.23 11:39, robert k Wild via discuss wrote:
hi all,
looking at this guide
https://www.ibm.com/support/pages/temporarily-reduce-space-taken-console-dat... <https://www.ibm.com/support/pages/temporarily-reduce-space-taken-console-database>
do i ideally have to stop the database before i truncate some tables ie
/opt/aspera/common/mysql/bin/mysql -u root -p'password' aspera_console TRUNCATE*fasp_sessions fasp_files fasp_rates * *jobs job_steps*
with the database stopped you would not be able to executed any SQL commands, including TRUNCATE. So no, do not stop the database before doing a TRUNCATE -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) MariaDB Corporation | http://www.mariadb.com/