Support » Plugin: WP Migrate DB » Import failed, error message

  • Resolved crashguru

    (@crashguru)


    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.

    http://wordpress.org/extend/plugins/wp-migrate-db/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Brad Touesnard

    (@bradt)

    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.

    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?

    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!
    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Import failed, error message’ is closed to new replies.