I am developing a site based on 126.96.36.199. I use Hostmonter, and they no longer support upgrades from 188.8.131.52 and beyond.
I’ve tried the manual upgrade via SSH, which was a disaster.
I’ve tried every possible solution there is out there, but I’m not a developer, and I don’t know much about the code. I couldn’t even get the DB dump as per wiki due to so many error messages. The SSH way of manual upgrade kept putting me on a message like “I must be running magento connect” despite sending in the command many times to run Magento Connect.
So what I did was a fresh install of 184.108.40.206 and the tried to import the database that I’ve backed up via Magento tools - backup and use phpMyAdmin to import the database, but I get the following error message:
CREATE TABLE `mgn_directory_country_region` (
`region_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`country_id` VARCHAR( 4 ) NOT NULL DEFAULT ‘0’,
`code` VARCHAR( 32 ) NOT NULL DEFAULT ‘’,
`default_name` VARCHAR( 255 ) DEFAULT NULL ,
PRIMARY KEY ( `region_id` ) ,
KEY `FK_REGION_COUNTRY` ( `country_id` )
) ENGINE = INNODB AUTO_INCREMENT =485 DEFAULT CHARSET = utf8 COMMENT = ‘Country regions’;
#1005 - Can’t create table ‘cctvrepo_mgn1.mgn_directory_country_region’ (errno: 150) (Details...)
Again, this is what I have and I am desperately looking for solutions:
1. was running 220.127.116.11 fine.
2. DB is backed up using tools - backup in Magento admin
3. deleted the entire 18.104.22.168 install
4. reinstalled 22.214.171.124 fresh
All I need to do now is to import the old DB and make it work, but I’m stuck at what you see above.
Any help is appreciated.