JBV, This looks like a server timeout. There is a mySQL server ini file parameter "ExecTimeLimit" There is also a phpMyAdmin ini file "LoginCookieValidity" timeout parameter. If you can't get those changed(especially "ExecTimeLimit" so you can do it by script) you will be forced to create a new table with a primary key and copy the data over in chunks small enough to avoid a timeout.
Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -----Original Message----- From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of jbv via use-livecode Sent: Saturday, April 29, 2023 7:40 AM To: How to use LiveCode Cc: j...@souslelogo.com Subject: mySQL and primary key 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
