distal-attribute
distal-attribute
distal-attribute
distal-attribute

Export many dabases

agrundner posted 1 year ago in Import/Export
Hi!

My database-root-user has connection to 200 Databases.
Can i export every database in a different file?

Database 1 => 1.sql
Database 2 => 2.sql

I don't want do use "directory export" because it creates a file for every table.

Please help! surprisedsurprisedsurprised
ansgar posted 1 year ago
No, you can export multiple dbs or a single one into one file. Or, do it in 200 steps.
agrundner posted 1 year ago
HAHA. Thats no solution! For nobody!
ansgar posted 1 year ago
Well, it is. It's just more work :)
ansgar posted 1 year ago
To be honest, having 200 databases to export is not a common usecase.

agrundner posted 1 year ago
I solve it with mysqldump on my server command line and a bash file...
ansgar posted 1 year ago
Yes, that's indeed a good choice for such rare situations.
agrundner posted 1 year ago
But thanks, Heidisql is greate since 5 years of use happyhappy
ansgar posted 1 year ago
I was just thinking you're one of the first Heidi users when you said 5 years. Indeed I started Heidi in April 2006, so it's already more than 8 years ago. Counting the early time to code MySQL-Front on top of it, that all started in August 2000 - 13 years ago.

The very first feedback mail from some Ben from Toronto: "Hi, I like your Mysql-front..." and included this very first question:
"1. can you set up an English website?"
It was a german website in the very beginning :)

Just being a bit nostaligic...
inverse posted 1 year ago
Good work angsar :)

Please login to leave a reply, or register at first.