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

Export many dabases

User, date Message
Written by agrundner
12 months ago
Category: Import/Export
4 posts since Tue, 08 Oct 13
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
Written by ansgar
12 months ago
5045 posts since Fri, 07 Apr 06
No, you can export multiple dbs or a single one into one file. Or, do it in 200 steps.
Written by agrundner
12 months ago
4 posts since Tue, 08 Oct 13
HAHA. Thats no solution! For nobody!
Written by ansgar
12 months ago
5045 posts since Fri, 07 Apr 06
Well, it is. It's just more work :)
Written by ansgar
12 months ago
5045 posts since Fri, 07 Apr 06
To be honest, having 200 databases to export is not a common usecase.
Written by agrundner
12 months ago
4 posts since Tue, 08 Oct 13
I solve it with mysqldump on my server command line and a bash file...
Written by ansgar
12 months ago
5045 posts since Fri, 07 Apr 06
Yes, that's indeed a good choice for such rare situations.
Written by agrundner
12 months ago
4 posts since Tue, 08 Oct 13
But thanks, Heidisql is greate since 5 years of use happyhappy
Written by ansgar
12 months ago
5045 posts since Fri, 07 Apr 06
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...
Written by inverse
12 months ago
3 posts since Thu, 10 Oct 13
Good work angsar :)
 

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