[MariaDB discuss] Re: stop database before truncate

yes i was trying to truncate more than one table but it didnt work, so i truncated one at a time, oh well thanks Hartmut On Mon, 3 Jul 2023 at 12:08, Hartmut Holzgraefe wrote: > On 03.07.23 12:22, robert k Wild wrote: > > have i got the syntax correct for the truncate command, can i run it al

[MariaDB discuss] Re: stop database before truncate

On 03.07.23 12:22, robert k Wild wrote: have i got the syntax correct for the truncate command, can i run it all on one command? start by showing the actual TRUNCATE command you are issuing, and the actual error you are getting back, that removes guessing from the process. I assume that you ar

[MariaDB discuss] Re: stop database before truncate

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 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 vi

[MariaDB discuss] Re: stop database before truncate

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-database

[MariaDB discuss] Re: stop database before truncate

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 do i ideally have to stop the database before