Skip to content

Instantly share code, notes, and snippets.

@kenci
Last active September 4, 2016 14:07
Show Gist options
  • Select an option

  • Save kenci/97f850fba8ef1e154d435ee563166d25 to your computer and use it in GitHub Desktop.

Select an option

Save kenci/97f850fba8ef1e154d435ee563166d25 to your computer and use it in GitHub Desktop.
Dump MySQL Databases
mysql -u username -h hostname.lan -p databasename < piwigo.sql
#!/bin/bash
echo "show databases;" | mysql -u admin --password='**' | while read databasename
do
echo dumping $databasename
mysqldump -u admin --password='**' "$databasename" >"$databasename.sql"
done
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment