I am trying to upgrade a Magento 1.3 store to 1.7. First, I ran the old Magento database through the database repair tool. Then I uploaded a fresh copy of Magento 1.7 to the server and went through the web based installer. I entered all the database information from the old Magento 1.3 database and hit continue. So far so good.
This is where it starts to confuse me. I check PHPMYADMIN and for the first while it looks like the database get updates(tables are added etc) and everything seems to be going fine.
After a couple hours, if I go back to the web based downloader it is still sitting there thinking and when I check the database it has stopped updating. There are no errors present and it just thinks and thinks. It seems to me that it is doing something, but there is no progression in the install. I have allowed this process to continue for a day and half now.
If I check the MYSQL processes by using the SHOW PROCESSLIST query it shows the following:
Status: Copy to tmp table
SQL Query: ALTER TABLE ‘sales_flat_order’ ADD_UNIQUE_ID’ (’increment_id’)
If anyone can provide some information into what they think is happening that would be greatly appreciated.