WP Migrate DB
[resolved] Import failed, error message (5 posts)

  1. crashguru
    Posted 3 years ago #

    SQL query:

    INSERT INTO time_zone_transition
    VALUES ( 1001, 1585443600, 4 ) ;
    #1226 - User 'admin' has exceeded the 'max_questions' resource (current value: 75000)

    Afterwards 500 Error ...
    Tried 3 times.
    It worked well on the same server with a different WP installation in a sub-directory.


  2. Brad Touesnard
    Plugin Author

    Posted 3 years ago #

  3. crashguru
    Posted 3 years ago #

    I believe what they discuss a there is a different issue, just the same reason for the DB to stop importing. I believe the issue was the input in the time_zone_transition field didnt work.
    But of course I am no expert for MySQL.

  4. crashguru
    Posted 3 years ago #

    I forgot to mention, the DB which I migrated 3 times w/o problems is from a German WP installation.
    The time_zone_transition field input might be different?

  5. crashguru
    Posted 3 years ago #

    After I typed above I got the glorious idea to look into the DB that worked and saw that this table was missing. ( its a clone, just in German)
    I made a copy of the DB that didnt migrate and deleted the table time_zone_transition.
    Import went through. Though, it didnt change some of the site tables, like site url.
    Howevver, now I am dealing with 404 page not found errors. Site works only with Default Permalink settings. This migration turns into a real nightmare ... but I am not blaming the plugin!

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP Migrate DB
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic


No tags yet.