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"
