• eliteeternity

    (@eliteeternity)


    I’m trying to import a database with Sequel Pro on my mac.

    When I try to import it, I see the following errors:

    [ERROR in query 56] Can’t find file: ‘./seal/wp_adrotate.frm’ (errno: 2)
    [ERROR in query 57] Can’t find file: ‘./seal/wp_adrotate_blocks.frm’ (errno: 2)
    [ERROR in query 58] Can’t find file: ‘./seal/wp_adrotate_groups.frm’ (errno: 2)
    [ERROR in query 59] Can’t find file: ‘./seal/wp_adrotate_linkmeta.frm’ (errno: 2)
    [ERROR in query 60] Can’t find file: ‘./seal/wp_adrotate_stats_tracker.frm’ (errno: 2)
    [ERROR in query 61] Can’t find file: ‘./seal/wp_adrotate_tracker.frm’ (errno: 2)
    [ERROR in query 62] Can’t find file: ‘./seal/wp_ak_twitter.frm’ (errno: 2)
    [ERROR in query 63] Can’t find file: ‘./seal/wp_az_indexes.frm’ (errno: 2)
    [ERROR in query 64] Can’t find file: ‘./seal/wp_blc_filters.frm’ (errno: 2)
    [ERROR in query 65] Can’t find file: ‘./seal/wp_commentmeta.frm’ (errno: 2)
    [ERROR in query 66] Can’t find file: ‘./seal/wp_comments.frm’ (errno: 2)
    [ERROR in query 67] Can’t find file: ‘./seal/wp_flag_album.frm’ (errno: 2)
    [ERROR in query 68] Can’t find file: ‘./seal/wp_flag_comments.frm’ (errno: 2)
    [ERROR in query 69] Can’t find file: ‘./seal/wp_flag_gallery.frm’ (errno: 2)
    [ERROR in query 70] Can’t find file: ‘./seal/wp_flag_pictures.frm’ (errno: 2)
    [ERROR in query 71] Can’t find file: ‘./seal/wp_gdsr_data_article.frm’ (errno: 2)
    [ERROR in query 72] Can’t find file: ‘./seal/wp_gdsr_data_category.frm’ (errno: 2)
    [ERROR in query 73] Can’t find file: ‘./seal/wp_gdsr_data_comment.frm’ (errno: 2)
    [ERROR in query 74] Can’t find file: ‘./seal/wp_gdsr_ips.frm’ (errno: 2)
    [ERROR in query 75] Can’t find file: ‘./seal/wp_gdsr_moderate.frm’ (errno: 2)
    [ERROR in query 76] Can’t find file: ‘./seal/wp_gdsr_multis.frm’ (errno: 2)
    [ERROR in query 77] Can’t find file: ‘./seal/wp_gdsr_multis_data.frm’ (errno: 2)
    [ERROR in query 78] Can’t find file: ‘./seal/wp_gdsr_multis_trend.frm’ (errno: 2)
    [ERROR in query 79] Can’t find file: ‘./seal/wp_gdsr_templates.frm’ (errno: 2)
    [ERROR in query 80] Can’t find file: ‘./seal/wp_gdsr_votes_log.frm’ (errno: 2)
    [ERROR in query 81] Can’t find file: ‘./seal/wp_ig_caticons.frm’ (errno: 2)
    [ERROR in query 82] Can’t find file: ‘./seal/wp_links.frm’ (errno: 2)
    [ERROR in query 83] Can’t find file: ‘./seal/wp_mbp_ninja_affiliate.frm’ (errno: 2)
    [ERROR in query 84] Can’t find file: ‘./seal/wp_mbp_ninja_affiliate_comments.frm’ (errno: 2)
    [ERROR in query 85] Can’t find file: ‘./seal/wp_mbp_ninja_affiliate_options.frm’ (errno: 2)
    [ERROR in query 86] Can’t find file: ‘./seal/wp_mbp_ninja_affiliate_posts.frm’ (errno: 2)
    [ERROR in query 87] Can’t find file: ‘./seal/wp_options.frm’ (errno: 2)
    [ERROR in query 88] Can’t find file: ‘./seal/wp_postmeta.frm’ (errno: 2)
    [ERROR in query 89] Can’t find file: ‘./seal/wp_posts.frm’ (errno: 2)
    [ERROR in query 90] Can’t find file: ‘./seal/wp_quiz_answer.frm’ (errno: 2)
    [ERROR in query 91] Can’t find file: ‘./seal/wp_quiz_question.frm’ (errno: 2)
    [ERROR in query 92] Can’t find file: ‘./seal/wp_quiz_quiz.frm’ (errno: 2)
    [ERROR in query 93] Can’t find file: ‘./seal/wp_redirection_groups.frm’ (errno: 2)
    [ERROR in query 94] Can’t find file: ‘./seal/wp_redirection_items.frm’ (errno: 2)
    [ERROR in query 95] Can’t find file: ‘./seal/wp_redirection_modules.frm’ (errno: 2)
    [ERROR in query 96] Can’t find file: ‘./seal/wp_rg_form.frm’ (errno: 2)
    [ERROR in query 97] Can’t find file: ‘./seal/wp_rg_form_meta.frm’ (errno: 2)
    [ERROR in query 98] Can’t find file: ‘./seal/wp_rg_form_view.frm’ (errno: 2)
    [ERROR in query 99] Can’t find file: ‘./seal/wp_rg_lead.frm’ (errno: 2)
    [ERROR in query 100] Can’t find file: ‘./seal/wp_rg_lead_detail.frm’ (errno: 2)
    [ERROR in query 101] Can’t find file: ‘./seal/wp_rg_lead_detail_long.frm’ (errno: 2)
    [ERROR in query 102] Can’t find file: ‘./seal/wp_rg_lead_meta.frm’ (errno: 2)
    [ERROR in query 103] Can’t find file: ‘./seal/wp_rg_lead_notes.frm’ (errno: 2)
    [ERROR in query 104] Can’t find file: ‘./seal/wp_sticky.frm’ (errno: 2)
    [ERROR in query 105] Can’t find file: ‘./seal/wp_term_relationships.frm’ (errno: 2)
    [ERROR in query 106] Can’t find file: ‘./seal/wp_terms.frm’ (errno: 2)
    [ERROR in query 107] Can’t find file: ‘./seal/wp_term_taxonomy.frm’ (errno: 2)
    [ERROR in query 108] Can’t find file: ‘./seal/wp_thesis_terms.frm’ (errno: 2)
    [ERROR in query 109] Can’t find file: ‘./seal/wp_usermeta.frm’ (errno: 2)
    [ERROR in query 110] Can’t find file: ‘./seal/wp_users.frm’ (errno: 2)

    BUT if I go in and Repair & Optimize the database (before exporting) AND THEN try to import, it goes off without a hitch.

    Any clues as to why this happens, or does WordPress have some sort of error log where I could find more info about these?

    Thanks

Viewing 7 replies - 1 through 7 (of 7 total)
  • esmi

    (@esmi)

    Those errors have nothing to do with WordPress.

    Thread Starter eliteeternity

    (@eliteeternity)

    I realize that WordPress didn’t develop the plugins, but the plugins were developed for WordPress, so I thought this forum might be a good place to start.

    Sorry to put you out.

    esmi

    (@esmi)

    Are you using a plugin to carry out this import?

    Thread Starter eliteeternity

    (@eliteeternity)

    No. I’m exporting directly from phpMyAdmin.

    esmi

    (@esmi)

    Then I’d try posting on a dedicated MAMP forum about this.

    Thread Starter eliteeternity

    (@eliteeternity)

    Damnit.

    On second though … yes, I am. I use VaultPress to do my backups.

    I now assume they are causing the problem.

    I just assumed that a clean export from phpmyadmin after optimizing/repairing was solving the problem.

    Looks like the finger can be pointed at VaultPress.

    Thanks for making me realize…

    You may repair sql server errors with the aid of utility below sql database repair it must aid you

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Errors When Importing SQL Database. A Repair/Optimize Solves Temporarily’ is closed to new replies.