Re: mySQL and primary key
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 > wrote: > > Hi list, > > I have a mySQL table with 1350 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
RE: mySQL and primary key
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 1350 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
Re: mySQL and primary key
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@lists.runrev.com> wrote: > Hi list, > > I have a mySQL table with 1350 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 > -- 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 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
mySQL and primary key
Hi list, I have a mySQL table with 1350 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
