• Arnaud's links
  • Home
  • RSS Feed
  • Tag cloud
  • Login
all links
  • MySQL Back-up: Take a mysqldump with each database in its own SQL File

    mysql -N -e 'show databases' | while read dbname; do mysqldump --complete-insert --routines --triggers --single-transaction "$dbname" > "$dbname".sql; done

    todo : regarder les options

    June 19, 2016 - permalink - https://ma.ttias.be/mysql-back-up-take-a-mysqldump-with-each-database-in-its-own-sql-file/
    backup dump mysql