'Large Database Updates' on 4.7 upgrade

[Chuck Passaro]

Hi all,

I was about to upgrade our community to 4.7, then I get this message:

 

We operate a dedicated server and I'm usually ok with the many things we need to do, but I simply don't understand how to do this.

Can someone give me an idiot's guide, stop by step, on how this is done. 

Best assume I know nothing and you're trying to explain to an alien 😆

Thanks,

Jim

[Marc Stridgen]

I can move your ticket to advanced self-hosting here, where people may be able to assist. We are unable, as part of support, to assist with how to run queries on your hosting unfortunately. You would be better not using something that is unmanaged if you are unsure how to run queries to be honest.

[Randy Calvert]

I received the same prompt but did not have to do anything manually. 

If you did, you would need to login to your server via SSH and access MySQL. If necessary, you would paste a command you need to run manually from the MySQL prompt that the upgrader would give you. 

Again, it’s likely you won’t need to… but IPB is trying to prepare you just in case. 

[Chuck Passaro]

1 hour ago, Marc Stridgen said:

I can move your ticket to advanced self-hosting here, where people may be able to assist. We are unable, as part of support, to assist with how to run queries on your hosting unfortunately. You would be better not using something that is unmanaged if you are unsure how to run queries to be honest.

Many thanks.

[Rick Vasquez]

On 7/8/2022 at 4:47 AM, Chuck Passaro said:

Many thanks.

you can use pt-online-schema change to do this if you have enough or like @Randy Calvert said you are able to just run this command from the sql CLI and it will just run and ask you to confirm that you ran it. Sometimes larger tables take a while to make changes to.