Tags: mysql,restore

Sort by: Date / Title /

  1. 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>
  2. 11 years ago by grummfy
    #Param #HOST : host of your database : localhost, sql.free.fr, .... #DATABASE : your database name #FILE.sql : the file to restore #USERNAME : your username access
    mysql -D DATABASE -u USERNAME -p -h HOST --default-character-set=utf8 < FILE.sql
    Paste this in your website: <script type="text/javascript" src="http://www.posteet.com/embed/833"></script>
  3. 11 years ago by spirit
    1. # Dump
    2. mysqldump -u user -p -h localhost --database base > base.sql
    3.  
    4. # Restore
    5. mysql -u user -p -h localhost base < base.sql
    Paste this in your website: <script type="text/javascript" src="http://www.posteet.com/embed/75"></script>
  4. sponsorised links

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