Backup all MySQL databases in separate files

1 month, 1 week ago 0
Posted in: Programování
mysql -uroot -proot -e 'show databases' | while read dbname; do mysqldump -uroot -proot --complete-insert "$dbname" > "$dbname".sql; done

Comments are closed.