[Plugin: WP SlimStat] Migration all tables to new server

  • Resolved Rhand

    (@rhand)


    15 years, 3 months ago

    I am trying to migrate all WP Slimstat (version 2.2.1) tables from one WordPress LAMP server with MySQL 4 to another LAMP Server with MySQL5 and PHP 5. Tables I imported into the new database are:

    1. wp_slim_visits.sql
    2. wp_slim_stats.sql (17MB gzipped so really large, put PMA seemed to handle it with interrupts checked)
    3. wp_slim_screenres.sql
    4. wp_slim_outbound.sql
    5. wp_slim_browsers.sql
    6. wp_slim_countries.sql

    All went well, well at least I thought so. I upgraded all plugins on new server and upgraded WordPress from 3.0.1 to 3.0.4. Slimstat was updated to 2.2.3. I only had to turn of mod_security as it did not allow me to enter and view Slimstat. But when I fixed that and went to the general Slimstat Dashboard all stats were not there. Is a migration like this possible? What table data is loaded in the first tab or general Dashboard of Slimstat? I wonder what table import did not go right..

    http://wordpress.org/extend/plugins/wp-slimstat/

    FYI:
    Old server: # MYSQL Version : 5.0.51a-24+lenny4-log
    # PHP Version : 5.2.6-1+lenny9

    New Server:#Apache/2.0.54 (Fedora)
    # MYSQL Version : 5.1.47
    PHP Version : 5.2.9

    No, I cannot access MySQL error logs as I am on a shared hoster using virtual hosting. yes I do have PMA access through Plesk.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter Rhand

    (@rhand)

    15 years, 3 months ago

    I dumbed the wp_slim_stats table on the new server through PMA and found out it is way smaller than the initial dump made on the old server, so I guess the import of this huge file did not work. Well, uncompressed the table was 140 MB and on the new server it became 33 MB. I guess it is too big for a proper import. Any idea how I can import it right now that I updated the plugin and WordPress?

    Thread Starter Rhand

    (@rhand)

    15 years, 3 months ago

    Any option to split a wp_slim_stats table into several pieces and importing them to recreate the same table again?

    Reading:
    http://forum.percona.com/index.php/t/71/
    http://stackoverflow.com/questions/1247841/how-can-i-split-a-mysql-table-into-multiple-tables-and-query-the-correct-arrea

    and thinking it would have been nice to have split the wp_slimstats table split into different tables in the first place as splitting a table seems to be harder for me than expected. After all some people prefer to keep stats for a long period and then this table tends to grow a lot.

    Thread Starter Rhand

    (@rhand)

    15 years, 3 months ago

    Importing WP Slimstat wp_slim_stats table now split into dumps of 100.000 rows each. Each dump is a bout 2 MB zipped. The MySQL server seems to be handing it. Let’s hope the Dashboard will be filled with data again shorty. Just did not realize earlier that PMA has a really neat way to dump x rows starting at row x under the export tab. I love PMA!

    Thread Starter Rhand

    (@rhand)

    15 years, 3 months ago

    Well, I do have some data in the Dashboard again. I only miss data on human visitors by day, languages on the visitors tab and content tab > average page views per visit per day, op exit pages, recent outbound links.

    NB Outbound and visits tables were both empty on old server running: — phpMyAdmin SQL Dump
    — version 2.11.8.1deb5+lenny6
    — http://www.phpmyadmin.net
    —
    — Host: localhost
    — Generation Time: Jan 22, 2011 at 11:25 AM
    — Server version: 5.0.51
    — PHP Version: 5.2.6-1+lenny9

    Plugin Contributor Jason Crouse

    (@coolmann)

    15 years, 3 months ago

    Good thing you were able to import all the data. Unfortunately that’s a limit that goes beyond WP SlimStat 🙂

    Camu

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘[Plugin: WP SlimStat] Migration all tables to new server’ is closed to new replies.