mySQL and primary key

[Mike Kerner]

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 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
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."