Tags: backups

Sort by: Date / Title /

  1. 8 years ago by spirit
    Create a specific user for backups purpose with read-only permissions
    1. GRANT SHOW DATABASES, SELECT, LOCK TABLES, RELOAD ON *.* to backup@localhost IDENTIFIED BY 'password';
    2. FLUSH PRIVILEGES;
    Paste this in your website: <script type="text/javascript" src="http://www.posteet.com/embed/2082"></script>
  2. 9 years ago by spirit
    Il faut avoir un backup de base tel qu'il y ait un dossier par base de donnée, un fichier SQL compressé par table. "-P 4" désigne le nombre de core.
    1. find -print0 | xargs -0 -n 1 -P 4 -I {} sh -c "zcat '{}' | mysql mydatabase"
    Paste this in your website: <script type="text/javascript" src="http://www.posteet.com/embed/2071"></script>

First / Previous / Next / Last / Page 1 of 1 (2 posteets)