<?xml version="1.0" encoding="UTF-8"?>
<!-- generator="FeedCreator 1.8" -->
<?xml-stylesheet href="https://wiki.darkou.fr/lib/exe/css.php?s=feed" type="text/css"?>
<rdf:RDF
    xmlns="http://purl.org/rss/1.0/"
    xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
    xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
    xmlns:dc="http://purl.org/dc/elements/1.1/">
    <channel rdf:about="https://wiki.darkou.fr/feed.php">
        <title>DokuWiki - tips</title>
        <description></description>
        <link>https://wiki.darkou.fr/</link>
        <image rdf:resource="https://wiki.darkou.fr/_media/wiki/dokuwiki.svg" />
       <dc:date>2026-04-15T14:44:14+00:00</dc:date>
        <items>
            <rdf:Seq>
                <rdf:li rdf:resource="https://wiki.darkou.fr/tips/markdown_vers_pdf_ou_html?rev=1681819838&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.darkou.fr/tips/mongodb?rev=1661166924&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.darkou.fr/tips/mysql?rev=1665181282&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.darkou.fr/tips/postgresql?rev=1664524071&amp;do=diff"/>
                <rdf:li rdf:resource="https://wiki.darkou.fr/tips/wget?rev=1679390009&amp;do=diff"/>
            </rdf:Seq>
        </items>
    </channel>
    <image rdf:about="https://wiki.darkou.fr/_media/wiki/dokuwiki.svg">
        <title>DokuWiki</title>
        <link>https://wiki.darkou.fr/</link>
        <url>https://wiki.darkou.fr/_media/wiki/dokuwiki.svg</url>
    </image>
    <item rdf:about="https://wiki.darkou.fr/tips/markdown_vers_pdf_ou_html?rev=1681819838&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2023-04-18T12:10:38+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Convertir du Markdown en PDF ou HTML</title>
        <link>https://wiki.darkou.fr/tips/markdown_vers_pdf_ou_html?rev=1681819838&amp;do=diff</link>
        <description>Convertir du Markdown en PDF ou HTML
Information


Cf NinjaTrappeur sur le canal IRC de PauLLA :



{ writeScriptBin, bash, lib, pandoc, texlive }:

writeScriptBin &quot;generate-document&quot; &#039;&#039;
#!${bash}/bin/bash
set -e

export PATH=&quot;${
  lib.makeBinPath ( [
    pandoc
    texlive.combined.scheme-medium
  ])
}&quot;
filename=$(basename &quot;$1&quot; | cut -f 1 -d &#039;.&#039;)
pandoc &quot;$1&quot; -f markdown \
       --pdf-engine=xelatex \
       -o &quot;$filename.pdf&quot; \
       -V &#039;geometry:margin=3.25cm&#039; \
       -V &#039;lang:en-US&#039; \
    …</description>
    </item>
    <item rdf:about="https://wiki.darkou.fr/tips/mongodb?rev=1661166924&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2022-08-22T11:15:24+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>MongoDB</title>
        <link>https://wiki.darkou.fr/tips/mongodb?rev=1661166924&amp;do=diff</link>
        <description>MongoDB

Sauvegarde

Un script que j&#039;utilise pour sauvegarder l&#039;ensemble des bases de données :


#! /bin/bash

BASE_DIR=&quot;/var/backup/mongo&quot;
DATE=$(date +%Y%m%d%H%M)
LOG=&#039;&#039;
PURGEDAYS=8

echo &quot;Backing up Mongo databases...&quot;
mongodump -o ${BASE_DIR}/${DATE}

echo &quot; &quot;
echo &quot; &quot;
echo &quot;Compressing backups..&quot;
cd ${BASE_DIR}
tar czvf ${DATE}.tar.gz ${DATE}
rm -rf ${DATE}

echo &quot; &quot;
echo &quot; &quot;
echo &quot;Removing old backup&quot;
find ${BASE_DIR}/ -name &quot;*.tar.gz&quot; -mtime +${PURGEDAYS} -delete -print</description>
    </item>
    <item rdf:about="https://wiki.darkou.fr/tips/mysql?rev=1665181282&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2022-10-07T22:21:22+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Mysql</title>
        <link>https://wiki.darkou.fr/tips/mysql?rev=1665181282&amp;do=diff</link>
        <description>Mysql

Quelques tips que je passe à chaque fois 3h à retrouver… 😅

Créer un utilisateur et lui affecter une base


CREATE DATABASE dbname;
CREATE USER &quot;dbuser&quot;@&quot;localhost&quot;;
SET password FOR &quot;dbuser&quot;@&quot;localhost&quot; = password(&#039;dbpassword&#039;);
GRANT ALL PRIVILEGES ON dbname.* TO &quot;dbuser&quot;@&quot;localhost&quot; IDENTIFIED BY &quot;dbpassword&quot;;
FLUSH PRIVILEGES;
EXIT;</description>
    </item>
    <item rdf:about="https://wiki.darkou.fr/tips/postgresql?rev=1664524071&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2022-09-30T07:47:51+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>PostgreSQL</title>
        <link>https://wiki.darkou.fr/tips/postgresql?rev=1664524071&amp;do=diff</link>
        <description>PostgreSQL

Sauvegarde et restauration

Sauvegarde


pg_dump -h host -p port -U user db -f file.sql


Restauration


psql -h host -U user -d db -f file.sql</description>
    </item>
    <item rdf:about="https://wiki.darkou.fr/tips/wget?rev=1679390009&amp;do=diff">
        <dc:format>text/html</dc:format>
        <dc:date>2023-03-21T09:13:29+00:00</dc:date>
        <dc:creator>Anonymous (anonymous@undisclosed.example.com)</dc:creator>
        <title>Wget</title>
        <link>https://wiki.darkou.fr/tips/wget?rev=1679390009&amp;do=diff</link>
        <description>Wget

Télécharger toute les images d&#039;un page web


wget -U &quot;Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:49.0) Gecko/20100101 Firefox/49.0&quot; --level=1 -e robots=off -nd -r -P &lt;dossier de destination&gt; -A jpg,png,jpeg -H &lt;page web&gt;


Voir man wget pour l&#039;explication des paramètres</description>
    </item>
</rdf:RDF>
