For the index, can you loggin with SSH to your server? When yes, go in the shop root, then in the folder “shell” and type “php -f indexer.php reindexall”. Sometimes this helps when the index cannot refreshed in the admin panel.
Broken indexes are a big problem, i`ve saw this dozends of time....there`s a official database repair tool, i would try it.
There`s also a new untested version on the site.
Yes, I also think it’s foreign key problem. When I migrate the database, some docs said I should choose “disable foreign key check” but I have not choose that item so the data base always have the problem.
Another problem for my magento is the old order records has not products details and have not “ship” item for each order, if I re-export the database with “disable foreign key check”, do you think everything will be ok, please?
When you dump with phpMyAdmin, you can add the “disable foreign key check” option to the dump. That means, that the dump runs normally und when you re-import the database (clear before) with the dump, the dump ignores the foreign key check during the import.
I install a new magento on other domain but when I import the database by phpMyAdmin, it show one error and I find there is any data imported.
I have attached the error picture, could you check that for us, please?
By the way, about the price reindex problem, if we don’t consider that, it will be fatal problem, please? If it’s not big problem, I want to keep this because I can’t find better methord to solve that.
If so, I think it’s no need to reinstall the blank Magento, is that right?
Today, I also tried another methord, which I copy all old server files and import the database to blank database and everything is ok but the problem is when I visit the new domain, it redirect to http://www.herawigs.com and I tried many methord to solve that but can’t work so I decide to install one blank Magento. Do you have any good idea to solve the redirect problem what I said, please?