Multi-table auto-seperate exports
My team and I have just started using this product to import, modify, and export our projects. We would like to say thank you so much for creating this product. Up until now we have tried using PMA, NaviCat, and SQLyog; and absolutely none of them come close to being able to do what this product does as fast or as clean as Heidi does. So first, thank you for your hard work!
I do have a question about this as I haven't yet been able to find an answer. Is there a way to export multiple tables from the selected database at once to a given directory and have it separate each table into files <tablename>.sql? Having to export 100+ tables one by one is a pain in the rear and very time consuming and takes away from development time. If there isn't a way to do this yet could this be considered a feature request for future releases? I will attempt to program a patch to allow this but my programming skills are a bit limited so I'll probably spend more time breaking stuff than making it work. xD
Currently HeidiSQL does not support exporting tables to seperate files. I would recommend using mysqldump.exe for such a job. All you have to do is to compose a commandline for each table you want to export, fx like this one:
mysqldump -hlocalhost -umyname -pmypass -fc:\temp\[TABLENAME].sql --opt dbname [TABLENAME]
Where [TABLENAME] is a dynamic variable in a loop over the result of
SHOW TABLES FROM dbname
That's doable with some lines of any programming language which is able to connect to your mysql server.
Thanks for the response. I will try this but I prefer to have the HeidiSQL header on my sql files, I'd rather use your program to do it 1 by 1. Would you consider making this an optional feature in one of the future versions of Heidi? I'm sure it would be beneficial to more than just me.
Please login to leave a reply, or register at first.