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
] On Behalf
Of jbv via use-livecode
Sent: Saturday, April 29, 2023 7:40 AM
To: How to use LiveCode
Cc: j...@souslelogo.com
Subject: mySQL and primary key
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" column.
I ha
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"
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" column.
I have tried in phpMyAdmin as well as in a script with
"ALTER TABLE myTable ADD PRIMARY KEY(id)", but each time
I get a "504 Gateway Timeout" error, and no index is cr
