transfer current slimstat tables to new installation

  • Resolved WP-Henne

    (@wp-henne)


    4 years, 1 month ago

    Hello!

    Because of several mistakes on the website I have made a new installation and would like to take the statistic data from the broken page.

    Export via Mysql-Dump and import works for many other plugins, I feel safe to do so.

    During import (drop all empty tables) I get error messages
    ” #1452 – Cannot add or update child line: a foreign key condition fails (test.wp_slim_events, CONSTRAINT fk_wp_slim_events_id FOREIGN KEY (id) REFERENCES wp_slim_stats (id) ON DELETE CASCADE ON UPDATE CASCADE)””

    There are no data in the archive table “wp_slim_stats_archive” yet, because the website has not been online for 30 days.

    Alternatively, would it be a solution to fill this archive table “wp_slim_stats_archive” per “now” and then transfer only these to the new database?

    Addition: During the import I didn’t pay attention to the ID’s of pages, mail etc., because I didn’t think it was relevant.

    Means: There are new pages, posts and elements with other ID’s from WordPress.

    I am thankful for every hint!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter WP-Henne

    (@wp-henne)

    To dismiss the error, it’s is only necessary to change the order of the tables while importing
    Table: wp_slim_stats before the wp_slim_events

    But now with all data in the new WordPress, nothing is shown.

    Thread Starter WP-Henne

    (@wp-henne)

    here we go again!

    Solution by myself:
    regarding this hint: https://magento.stackexchange.com/questions/140857/how-to-disable-or-remove-foreign-key-before-importing-database-to-phpmyadmin

    It’s the best way to export lik the description, import at phpmyadmin on the bottom line uncheck “Enable foreign key checks” or disable manualy with SQL.

    Import tables and after that those sql:
    ALTER TABLEwp_slim_events`
    ADD CONSTRAINT fk_wp_slim_events_id FOREIGN KEY (id) REFERENCES wp_slim_stats (id) ON DELETE CASCADE ON UPDATE CASCADE;
    SET FOREIGN_KEY_CHECKS=1;`

    If any other has dificulties, please ask here, i’d like to help.

    Cheers!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘transfer current slimstat tables to new installation’ is closed to new replies.