First of all i like your tool a lot since i was looking for exacly something like this. However, i have few sugestions.
First of all i noticed that it creates subprocesses while backing up data. While this is a great idea i think it should also have limit for maximum connections/subprocesses that program can made. Ive run into situation very quickly when "Too many connections" were made (i have limit on 1000) and websites didnt work and also backup tool didnt work - empty files.
Second thing which would be great i think is to use some advanced options like check if use locking, flushing and meybe other. The thing i noticed that mysqldump flushes all tables before dump - so when many subprocesses are created mysqldump flushes tables in every subprocess - which slows down backing up process dramatically.
The third and last - white database list choosable insteed of black list - since it may happen that you want to backup only one database from many and in case of white datalist it will be easier to write it down. The list could also be as checkboxes.
Those are just my suggestions on how this tool may improve. I hope that you could consider those in your future releases.
Best,
Wojciech
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
(you are not by coincidence the same guy from Poland (last name starting with an F) from rentacoder that did some mysql stored procedure coding for me a couple of years ago are you?)
I read your comments and you have some good points. The project was made for my need to backup my home database. Since it worked for me, I thought others might find it useful as well.
I have to think about how to handle the issues you mentioned. If I have some spare time (quit busy with the family), I’ll try to implement some solutions.
In the mean time, If you have some coding suggestions, it’s open source…so please feel free to alter the code ;-)
Regards,
Matthijs
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
in the latest version (version 1.2.1) the sub processes issue has been resolved. You can now set the number of processes you want the program to run for the dumps.
As of version 1.2, there was already a choice between black and white lists.
Hi,
First of all i like your tool a lot since i was looking for exacly something like this. However, i have few sugestions.
First of all i noticed that it creates subprocesses while backing up data. While this is a great idea i think it should also have limit for maximum connections/subprocesses that program can made. Ive run into situation very quickly when "Too many connections" were made (i have limit on 1000) and websites didnt work and also backup tool didnt work - empty files.
Second thing which would be great i think is to use some advanced options like check if use locking, flushing and meybe other. The thing i noticed that mysqldump flushes all tables before dump - so when many subprocesses are created mysqldump flushes tables in every subprocess - which slows down backing up process dramatically.
The third and last - white database list choosable insteed of black list - since it may happen that you want to backup only one database from many and in case of white datalist it will be easier to write it down. The list could also be as checkboxes.
Those are just my suggestions on how this tool may improve. I hope that you could consider those in your future releases.
Best,
Wojciech
Hi Wojchiech,
(you are not by coincidence the same guy from Poland (last name starting with an F) from rentacoder that did some mysql stored procedure coding for me a couple of years ago are you?)
I read your comments and you have some good points. The project was made for my need to backup my home database. Since it worked for me, I thought others might find it useful as well.
I have to think about how to handle the issues you mentioned. If I have some spare time (quit busy with the family), I’ll try to implement some solutions.
In the mean time, If you have some coding suggestions, it’s open source…so please feel free to alter the code ;-)
Regards,
Matthijs
Hi Wojciech ,
in the latest version (version 1.2.1) the sub processes issue has been resolved. You can now set the number of processes you want the program to run for the dumps.
As of version 1.2, there was already a choice between black and white lists.
You can download 1.2.1 here https://sourceforge.net/projects/mysqlbutool/files/
Kind regards,
Matthijs