vendredi 23 septembre 2016

MySQL : Automatisation of the re-execution of Queries from History

I have a simple MySQL database and I need to get the queries which have been already executed , and develop a script php - shell which may re-execute those queries whatever i want : so

  1. First Step :

i started by transfer my queries to a log file by doing this configuration within phpmyadmin

  • SET GLOBAL log_output = "FILE"; which is set by default.
  • SET GLOBAL general_log_file = "/path/to/your/logfile.log";
  • SET GLOBAL general_log = 'ON';

    2.Second Step :

i need to automatisate the re-execution of those queries which are in my log file after sorting them with date (for example : re-execute the queries of "today") .

I have had sugesstions like scripts php or shell but i need to have a script which may be usefull within windows and linux , so that i'm looking for a tool which may do that ,

any suggestions ?

Aucun commentaire:

Enregistrer un commentaire