SJ77 Posted March 31, 2019 Posted March 31, 2019 Still trying to get 4.4 to install. On test instillation this time instead of live site. YAAAY However, during the upgrade from 4.3.6 I noticed one of the queries times out. I have a lot of records to add this key to apparently. Then if I try to run it again it doesn't work because the partially upgraded DB already has the key. What should I do? Now it says this
SJ77 Posted March 31, 2019 Author Posted March 31, 2019 FYI: my nginx keepalive_timeout is set to 15;
Makoto Posted March 31, 2019 Posted March 31, 2019 You're going to need to increase that timeout. Generally, the upgrader will prompt you to run more intensive queries manually, and you should do those via the MySQL CLI directly, not phpMyAdmin (since you're self-hosted). If the queries have already been run and you're sure they have, the upgrader should allow you to proceed as normal.
Ryan Ashbrook Posted April 1, 2019 Posted April 1, 2019 It should be noted, that if you do run these queries via phpMyAdmin, and they do timeout, that the query is likely still running on the server. To confirm, run SHOW PROCESSLIST, which will show all of the queries currently running. You can then re-run that to see if it's still running, and once it disappears from the list, it's finished. But yes, it's better to run them via CLI to avoid the timeout.
SJ77 Posted April 1, 2019 Author Posted April 1, 2019 I realize this is slipping into noob zone for most of the pro's here but I have always used PHPMyAdmin for queries. I can't get this to run on the command line. Here is what I am trying. mysql -h localhost -uMyUser -pMyPass -e "ALTER TABLE `core_reputation_index` ADD KEY `leaderboard` (`rep_class`,`rep_date`,`member_received`,`rep_rating`);MyDataBase"; And getting the following error. ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ADD KEY (,,,)' at line 1 What am I doing wrongly?
Ryan Ashbrook Posted April 1, 2019 Posted April 1, 2019 Do this instead: > mysql -h localhost -uUSER -pPASS mysql> use "MyDatabase"; mysql> ALTER TABLE `core_reputation_index` ADD KEY `leaderboard` (`rep_class`,`rep_date`,`member_received`,`rep_rating`); Then you can just run any queries as prompted without having to login each time. Then, once your upgrade has finished, just do this to logout: mysql> exit
TDBF Posted April 9, 2019 Posted April 9, 2019 If you don't like using CMD or MyPHPAdmin then I would suggest you give HeidiSQL a try. You will be able to INSERT large Databases without the worry of timing out.
Morgin Posted May 5, 2019 Posted May 5, 2019 On 4/9/2019 at 5:06 AM, TDBF said: If you don't like using CMD or MyPHPAdmin then I would suggest you give HeidiSQL a try. You will be able to INSERT large Databases without the worry of timing out. HeidiSQL is such a great interface. +1 to this.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.