If you can connect remotely to the server then try using MySQL workbench
(available from Oracle) if not then you will need to SSH to the server, login
to mysql on command line and do it there.
> On 29 Apr 2023, at 9:40 pm, jbv via use-livecode
> wrote:
>
> Hi list,
>
> I have a mySQL table w
JBV,
This looks like a server timeout. There is a mySQL server ini file parameter
"ExecTimeLimit" There is also a phpMyAdmin ini file "LoginCookieValidity"
timeout parameter. If you can't get those changed(especially "ExecTimeLimit"
so you can do it by script) you will be forced to create a new ta
is this a local table?
the 504 sounds like you're connecting via an api
On Sat, Apr 29, 2023 at 7:41 AM jbv via use-livecode <
use-livecode@lists.runrev.com> wrote:
> Hi list,
>
> I have a mySQL table with 1350 entries that weights
> almost 20 Gb.
> I need to create a primary key on the "id"
I don't know of a Livecode syntax per se to do this (i.e some syntax
like: set the permissions of file tFile to read-only)
You can do this in Livecode using the shell() function (see the
dictionary) to issue applicable mac or win command lines. For eample a
Google search shows the command line
Only just catching up with this (been walking in Scotland)…
Probably not tremendously informative now, but I’m not using Levure, I am using
backdrop, and on Ventura.
I’ll check the state of RaiseWindows when I can - would it be expected to
change depending on backdrop use?
Best Wishes,
David
Hi folks,
Really simple question that I can’t see having been asked before, so here goes…
I have a stack that outputs small text files. Each includes a hash value
referencing part of itself that can be checked subsequently, so any change to
the text can be flagged.
Is there a way I can easi