Useful Snippets

Useful Snippets


This blog is used to collect useful snippets related to Linux, PHP, MySQL and more. Feel free to post comments with improvements or questions!

July 2020
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  

Categories


Dump all MySQL databases on a Linux server with a single line of bash

Stanislav KhromovStanislav Khromov

Run this in the folder where you want the files dumped:

for I in $(mysql -uroot -p -e 'show databases' -s --skip-column-names); do mysqldump $I  > "$I.sql"; done

Source

Web Developer at Aftonbladet (Schibsted Media Group)
Any opinions on this blog are my own and do not reflect the views of my employer.
LinkedIn
Twitter
WordPress.org Profile
Visit my other blog

Comments 0
There are currently no comments.