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 <robertkwild@gmail.com> wrote:
Thanks Hartmut
On Mon, 3 Jul 2023, 10:49 Hartmut Holzgraefe via discuss, < discuss@lists.mariadb.org> 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-dat... < https://www.ibm.com/support/pages/temporarily-reduce-space-taken-console-dat...
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 -- discuss@lists.mariadb.org To unsubscribe send an email to discuss-leave@lists.mariadb.org
-- Regards, Robert K Wild.