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