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