Skip to content
Snippets Groups Projects
init.md 474 B
Newer Older
  • Learn to ignore specific revisions
  • Rémi PAILHAREY's avatar
    Rémi PAILHAREY committed
    # Init first prices data
    
    ## Local
    
    If the script is not working (problem with secure_file_priv variable), use the import in phpMyAdmin:
    
    - Ignore the request for the first line
    - Select format "CVS using LOAD DATA"
    - Choose the right column separator ","
    - Then launch the execution
    
    ## Rec/Prod
    
    - Connect to mysql docker container
    
    ```
    docker exec -it <container-id> bash
    ```
    
    - Open mysql shell
    
    ```
    mysql --local-infile=1 -uroot -p backoffice < /dbinit/dbinit.sql
    
    ```