mySQL and primary key

Monte Goulding monte.goulding at
Mon May 1 00:41:17 EDT 2023

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 <use-livecode at> wrote:
> Hi list,
> I have a mySQL table with 13500000 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 created.
> What else can I try ?
> Thank you in advance.
> jbv
> _______________________________________________
> use-livecode mailing list
> use-livecode at
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:

More information about the use-livecode mailing list