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-database
<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/
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
