Running SQL Query to export the data from MySQL Database

  • Resolved Jay

    (@jaytfl)


    3 years, 9 months ago

    Hi Team,

    First of all, thank you so much for creating such an awesome plugin.

    Especially, the APIs part to track down the list of all the page views, and other purposes as well.

    However, recently I have been getting quite a few visitors and thus the size of the database is also increasing.

    I wanted to get some guidance on what SQL query to run at the straight database level to export the data from phpMyAdmin only, and not via wordpress admin panel.

    Thanks,
    Jay.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Jay

    (@jaytfl)

    3 years, 9 months ago

    Not to mention that I have overridden the 60 days rule to make sure that the older data does not get deleted from the database.

    As of now, my exported simple history CSV file size is around 70 mb, and taking way too much time to get it exported.

    And thus looking for an alternative in a way of running a SQL query.

    Thread Starter Jay

    (@jaytfl)

    3 years, 9 months ago

    Also, wanted to check if there is a way to export the data from Dashboard->Simple History because I can see no export filters under Settings->Simple History.

    Plugin Author eskapism

    (@eskapism)

    3 years, 8 months ago

    The database layout is quite simple. Two tables: wp_simple_history and wp_simple_history_contexts. Take a look at them and I think you soon will understand how it works. I do however don’t think it’s possible to export the history using just a simple sql query. Each logged entry uses a simple “template system” so you need to combine the tables using code I think. Perhaps it’s possible using just SQL but I’m not that good at SQL to know how to do it :/

    Thread Starter Jay

    (@jaytfl)

    3 years, 7 months ago

    Hi there,

    Thanks for your response.

    I was able to figure it out on my own, eventually.

    Regards,
    Jay.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Running SQL Query to export the data from MySQL Database’ is closed to new replies.