mySQL and primary key

[Monte Goulding]

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 lists.runrev.com> 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 lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode