Dump journalier vers partage réseau

  • alexbzh
  • Topic Author
  • New Member
  • New Member
More
4 years 5 months ago #2280 by alexbzh
Dump journalier vers partage réseau was created by alexbzh
Bonjour, je souhaiterais planifier un dump journalier de ma base Grr vers un partage réseau.
J'ai fais un petit script bash qui fais bien un dump par contre le fichier .sql obtenu ne ressemble pas vraiment a celui que l'on obtient en utilisant l'interface admin de grr.
Est il possible d'utilisé admin_save_mysql.php avec un crontab pour exécuté automatiquement une sauvegarde? Je n'y arrive pas, il y a t'il quelqu'un qui pourrais m'aiguiller?
Si vous avez d'autre idée je suis preneur . Merci

Please Log in or Create an account to join the conversation.

  • Yan
  • Developpeur GRR
  • Developpeur GRR
More
4 years 5 months ago #2282 by Yan
Replied by Yan on topic Dump journalier vers partage réseau
Bonjour,
avez-vous essayé la méthode proposée dans la page GRR341/admin/admin_config4.php ?
Cordialement,
YN

Please Log in or Create an account to join the conversation.

  • alexbzh
  • Topic Author
  • New Member
  • New Member
More
4 years 5 months ago #2284 by alexbzh
Replied by alexbzh on topic Dump journalier vers partage réseau
Bonjour Yan,
oui mais j'ai des erreurs.

PHP Warning: include(): Failed opening '../include/connect.inc.php' for inclusion (include_path='.:/usr/share/php') in /var/www/grr/admin/admin_save_mysql.php on line 40
PHP Warning: include(../include/config.inc.php): failed to open stream: No such file or directory in /var/www/grr/admin/admin_save_mysql.php on line 41
PHP Warning: include(): Failed opening '../include/config.inc.php' for inclusion (include_path='.:/usr/share/php') in /var/www/grr/admin/admin_save_mysql.php on line 41
PHP Warning: include(../include/misc.inc.php): failed to open stream: No such file or directory in /var/www/grr/admin/admin_save_mysql.php on line 42
PHP Warning: include(): Failed opening '../include/misc.inc.php' for inclusion (include_path='.:/usr/share/php') in /var/www/grr/admin/admin_save_mysql.php on line 42
PHP Warning: include(../include/functions.inc.php): failed to open stream: No such file or directory in /var/www/grr/admin/admin_save_mysql.php on line 43
PHP Warning: include(): Failed opening '../include/functions.inc.php' for inclusion (include_path='.:/usr/share/php') in /var/www/grr/admin/admin_save_mysql.php on line 43
PHP Notice: Undefined variable: dbsys in /var/www/grr/admin/admin_save_mysql.php on line 44
PHP Warning: include(../include/.inc.php): failed to open stream: No such file or directory in /var/www/grr/admin/admin_save_mysql.php on line 44
PHP Warning: include(): Failed opening '../include/.inc.php' for inclusion (include_path='.:/usr/share/php') in /var/www/grr/admin/admin_save_mysql.php on line 44
PHP Warning: include(../include/settings.class.php): failed to open stream: No such file or directory in /var/www/grr/admin/admin_save_mysql.php on line 45
PHP Warning: include(): Failed opening '../include/settings.class.php' for inclusion (include_path='.:/usr/share/php') in /var/www/grr/admin/admin_save_mysql.php on line 45
PHP Fatal error: Uncaught Error: Class 'Settings' not found in /var/www/grr/admin/admin_save_mysql.php:46
Stack trace:
#0 {main}
thrown in /var/www/grr/admin/admin_save_mysql.php on line 46

Please Log in or Create an account to join the conversation.

  • Yan
  • Developpeur GRR
  • Developpeur GRR
More
4 years 5 months ago #2286 by Yan
Replied by Yan on topic Dump journalier vers partage réseau
c'est un problème d'include_path : php ne cherche pas au bon endroit.
Je cherche une solution.

Please Log in or Create an account to join the conversation.

  • alexbzh
  • Topic Author
  • New Member
  • New Member
More
4 years 5 months ago - 4 years 5 months ago #2287 by alexbzh
Replied by alexbzh on topic Dump journalier vers partage réseau
ok merci c'est très sympas
Last edit: 4 years 5 months ago by alexbzh.

Please Log in or Create an account to join the conversation.

  • Yan
  • Developpeur GRR
  • Developpeur GRR
More
4 years 5 months ago #2288 by Yan
Replied by Yan on topic Dump journalier vers partage réseau
Sur quelle version de GRR travaillez-vous ?
Il faudrait essayer de compléter les directives include en ajoutant le chemin vers le fichier : include(dirname(__FILE__).'/../include/connect.inc.php'); et ainsi de suite.
Merci de nous dire si votre problème est ainsi résolu.

Please Log in or Create an account to join the conversation.

  • alexbzh
  • Topic Author
  • New Member
  • New Member
More
4 years 5 months ago #2291 by alexbzh
Replied by alexbzh on topic Dump journalier vers partage réseau
Yan, merci pour ton aide. J'ai modifier les include dans le script php et effectivement j'ai moins d'erreurs, plus que deux voici le retour d'erreur:

PHP Warning: include(/var/www/grr/admin/../include/$dbsys.inc.php): failed to open stream: No such file or directory in /var/www/grr/admin/admin_save_mysql.php on line 48
PHP Warning: include(): Failed opening '/var/www/grr/admin/../include/$dbsys.inc.php' for inclusion (include_path='.:/usr/share/php') in /var/www/grr/admin/admin_save_mysql.php on line 48
PHP Fatal error: Uncaught Error: Call to undefined function grr_sql_query1() in /var/www/grr/include/settings.class.php:14
Stack trace:
#0 /var/www/grr/admin/admin_save_mysql.php(52): Settings::load()
#1 {main}
thrown in /var/www/grr/include/settings.class.php on line 14

Please Log in or Create an account to join the conversation.

  • Yan
  • Developpeur GRR
  • Developpeur GRR
More
4 years 5 months ago #2293 by Yan
Replied by Yan on topic Dump journalier vers partage réseau
Bonjour,
je pense à un problème de syntaxe, la variable $dbsys n’est pas évaluée. En remplaçant $dbsys par mysql dans l’include concerné, cela devrait marcher.
Cordialement,
YN

Please Log in or Create an account to join the conversation.

  • alexbzh
  • Topic Author
  • New Member
  • New Member
More
4 years 5 months ago #2294 by alexbzh
Replied by alexbzh on topic Dump journalier vers partage réseau
juste remplacer $dbsys par mysql? sans rien rajouter d'autre?

Please Log in or Create an account to join the conversation.

  • Yan
  • Developpeur GRR
  • Developpeur GRR
More
4 years 5 months ago #2295 by Yan
Replied by Yan on topic Dump journalier vers partage réseau
Je pense que c’est suffisant pour cette erreur. Essayez et dites-nous si c’est OK.

Please Log in or Create an account to join the conversation.

Moderators: Yan