have i got the syntax correct for the truncate command, can i run it all on one command?
On Mon, 3 Jul 2023 at 10:52, robert k Wild <[email protected]> wrote: > Thanks Hartmut > > On Mon, 3 Jul 2023, 10:49 Hartmut Holzgraefe via discuss, < > [email protected]> wrote: > >> 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] >> > -- Regards, Robert K Wild.
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
