Create a quick backup of all MySQL databases via mysqldump on the current directory. Replace USERNAME and PASSWORD with your own.
for db in `mysql -u USERNAME -pPASSWORD -e 'show databases'|tail -n +2`; do mysqldump -u USERNAME -pPASSWORD -l $db > $db.sql; done;
If you enjoyed this article, please consider sharing it!
Thanks for writing about this. There’s a heap of good tech info on the internet. You’ve got a lot of that info here on your site. I’m impressed – I try to keep a couple blogs reasonably live, but it’s a struggle sometimes. You’ve done a big job with this one. How do you do it?
Your site is great!