Migration problems (large database)

  • Resolved Mikko Saari

    (@msaari)


    9 months, 3 weeks ago

    I have a large database of stats (1.7 million rows in _koko_analytics_post_stats), and the migration times out. Is it possible to run the migration from command line somehow to avoid the timeout? I’d like to keep all my existing stats, while getting the new treats – this site has lots of taxonomy page traffic and is the main reason I’ve been asking for this feature.

Viewing 3 replies - 16 through 18 (of 18 total)
1 2
  • Thread Starter Mikko Saari

    (@msaari)

    9 months, 3 weeks ago

    I decided to take the nuclear option: I reset all the stats. I have the backup from this morning if I miss the old stuff, and since the whole method of calculating the stats has changed, it’s best to start fresh.

    Oh, and I bought the Pro. Thanks for all your hard work!

    Plugin Author Danny van Kooten

    (@dvankooten)

    9 months, 3 weeks ago

    Oh wow. That’s a clean slate @msaari. But that should definitely do the trick – provided your database tables are indeed correct (the reset button only truncates them – it does not re-create them).

    Thank you for throwing in some financial support. I truly appreciate it. Today and yesterday were hectic, mistakes were made, lessons were learned.

    Thread Starter Mikko Saari

    (@msaari)

    9 months, 3 weeks ago

    This is an excellent exercise in letting go of things; that has been a theme for me this year. Some time ago I couldn’t have thought of doing it this way.

    I really appreciate your responsiveness and support, as a fellow plugin author I know what it is.

Viewing 3 replies - 16 through 18 (of 18 total)
1 2

The topic ‘Migration problems (large database)’ is closed to new replies.