Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
jucs Posted July 12, 2021 Posted July 12, 2021 Was going to finally take the upgrade step and ran into this below. I do know how to pull up PhpMyAdmin and hit the Query tab. I assume the software will tell me the exact query to use and I will then submit it via PhpMyAdmin where I have the arrow in the attached screen shot? I am just making sure I am fully prepared to do this without getting hosed. Thanks! Large Database Updates During this upgrade some changes need to be made to large database tables. Trying to do this automatically may time out, so you will be prompted to run the queries manually when required. Before continuing, connect to your your MySQL server's command line so that you will be ready to run the queries when prompted. If you are not sure how to do this, you should contact your hosting provider or system administrator for assistance. TABLE ROWS SIZE core_search_index 763,422 327.59 MB
jucs Posted July 12, 2021 Author Posted July 12, 2021 1 minute ago, Adriano Faria said: Click in SQL to run the queries I was just going to ask this instead. Got it. Thanks! Anything else to do manually if need be? That I should know before I start? Thanks!
Miss_B Posted July 12, 2021 Posted July 12, 2021 Before you run any sql query it is best to always make a backup of the database. Davyc 1
CoffeeCake Posted July 12, 2021 Posted July 12, 2021 (edited) The reason IPS is asking you to run these on the SQL server itself is because PHP-based queries may time out depending on the configuration of your web server, PHP, and MySQL instance. Long story short: do not use phpMyAdmin to do this. Just like IPS, it runs through your web server and PHP. There is no difference between phpMyAdmin and the upgrader. You should instead connect directly to your MySQL instance via command line to run these queries. Typically, this will involve the mysql command while connected to SSH in a Linux environment. https://dev.mysql.com/doc/refman/8.0/en/mysql.html 4 hours ago, jucs said: Before continuing, connect to your your MySQL server's command line so that you will be ready to run the queries when prompted. If you are not sure how to do this, you should contact your hosting provider or system administrator for assistance. Read that carefully. It does not say phpMyAdmin. Edited July 12, 2021 by CoffeeCake
jucs Posted July 12, 2021 Author Posted July 12, 2021 1 hour ago, CoffeeCake said: The reason IPS is asking you to run these on the SQL server itself is because PHP-based queries may time out depending on the configuration of your web server, PHP, and MySQL instance. Long story short: do not use phpMyAdmin to do this. Just like IPS, it runs through your web server and PHP. There is no difference between phpMyAdmin and the upgrader. You should instead connect directly to your MySQL instance via command line to run these queries. Typically, this will involve the mysql command while connected to SSH in a Linux environment. https://dev.mysql.com/doc/refman/8.0/en/mysql.html Read that carefully. It does not say phpMyAdmin. Well, this didn't need to occur thank goodness. However, this is completely unreasonable to think you can have your server admin real time online doing these command line queries and frankly the majority of people are not SSH and Unix/MysSqul command line up to speed to go connect and do this. themselves. Just my 2 cents.
CoffeeCake Posted July 12, 2021 Posted July 12, 2021 16 minutes ago, jucs said: However, this is completely unreasonable to think you can have your server admin real time online doing these command line queries and frankly the majority of people are not SSH and Unix/MysSqul command line up to speed to go connect and do this. themselves. When self-hosting, there are skill sets that you will need to have and develop. IPS offers cloud-based packages for those customers that want a fully managed experience, and alternatively you can develop those skills yourself or contract with a provider to help with these sorts of things. For smaller databases, this isn't an issue, yet you get the warning you saw when tables exceed certain sizes that may time out. It seems that your install has some larger tables, so brushing up on how to handle this yourself would be well advised. The alternative is that the upgrader doesn't warn you, it times out, and you end up with issues due to the timeout. These issues vary greatly depending on what MySQL is doing in the background.
jucs Posted July 12, 2021 Author Posted July 12, 2021 12 minutes ago, CoffeeCake said: When self-hosting, there are skill sets that you will need to have and develop. IPS offers cloud-based packages for those customers that want a fully managed experience, and alternatively you can develop those skills yourself or contract with a provider to help with these sorts of things. For smaller databases, this isn't an issue, yet you get the warning you saw when tables exceed certain sizes that may time out. It seems that your install has some larger tables, so brushing up on how to handle this yourself would be well advised. The alternative is that the upgrader doesn't warn you, it times out, and you end up with issues due to the timeout. These issues vary greatly depending on what MySQL is doing in the background. For sure. Thanks for the clarification btw. Next time with such a big upgrade, I will have to learn how to run the queries myself via the commend line for sure. 🙂
Fast Lane! Posted July 12, 2021 Posted July 12, 2021 1 hour ago, jucs said: For sure. Thanks for the clarification btw. Next time with such a big upgrade, I will have to learn how to run the queries myself via the commend line for sure. 🙂 log in to your account via SSH. Type "mysql" then hit enter. Then type "use database" (where database is your database name). Then you can run the queries they tell you to.
jucs Posted July 12, 2021 Author Posted July 12, 2021 1 hour ago, Fast Lane! said: log in to your account via SSH. Type "mysql" then hit enter. Then type "use database" (where database is your database name). Then you can run the queries they tell you to. Best SSH client to use? Thanks!
Fast Lane! Posted July 15, 2021 Posted July 15, 2021 (edited) On mac, just use terminal. You can ssh into your host computer with this command line: ssh -p port domain.com -l username where port, domain and username are your values. Edited July 15, 2021 by Fast Lane!
Recommended Posts