Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updates.... still the same MySQL import error...

...

Nope... still same error; I will revert the change in the php.ini file... as that had no impact it seems!


...

Try #5: This time, with Views caching disabled, because upon inspecting the import, it turns out that it has error'd out on the caching table each time:

Image Added


So on the live site, we will not only disable Views caching, but also clear out the cache overall and then export the DB:

Image Added

As can be seen, Views caching is not disabled... so let's disable it...

Image Added


Image Added


Image Added


Image Added


Image Added


Image Added


Image Added


Alright, let's re-export and then import again, and see how it fares this time...

Image Added


Prior to importing, need to drop the half-imported DB:

Image Added


Image Added


Image Added


Alright... we get confirmation that prep DB been dropped... let's import the database again...

Image Added


Image Added


Image Added


Let's check where it stopped...

Image Added


Yep... it's the same table that is causing the import problem... each failed import has stopped at cache_menu — more research time!