Skip to content
Snippets Groups Projects

website db migration

  • Clone with SSH
  • Clone with HTTPS
  • Embed
  • Share
    The snippet can be accessed without any authentication.
    Authored by Dirk Sarpe
    Edited
    truncate-website-tables.sh 200 B
    #!/bin/bash
    
    typodb=idiv_website # staging
    # typodb=wwwidiv # live
    tables=('index_rel' 'index_fulltext' 'index_phash' 'tt_news')
    for table in ${tables[@]}; do
      mysql -e "truncate $typodb.$table"
    done
    0% Loading or .
    You are about to add 0 people to the discussion. Proceed with caution.
    Please register or to comment