Jump to content

manual sql query during upgrade - how long should it take?

ssolstad
ssolstad
in Technical Problems

Featured Replies

Posted

This might be a really stupid question, but I'll have a go anyway;

I'm in the middle of upgrading from 3.4 to the current version of IPB and was asked to run a manual query  

ALTER TABLE ibf_forums_posts DROP INDEX post;

I'm running this query now, but it seems to take forever. How long should such a query take to finis? I understand it is depending on the size of the table, but are there any guidelines/indications you can give?

As you indicated it really depends on the size of the table, the performance of the server etc.

If you have a lot of posts, dropping an index (and then rebuilding them) may take quite a while

  • Author

It's taken 1 hour and 40 minutes so far...

I'm a novise when it comes to sql databases and running scripts, so I believed I might be doing something wrong. I'm using MySQL workbench and I can't find a way to se what is actually going on - I have barely used the workbench before so it is unfamiliar to me...

 

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

Recently Browsing 0

  • No registered users viewing this page.