MySQL Script to export/import a database table by table.

Hello, I'm currently unable to export my MySQL database due to it's sheer size (Around 20GB), I've already tried various things like: - **Input**; Modifying and toying around with various configs like packet size in /etc/my.conf. **Output**; Always the same, Around 10GB in size it just stops exporting and that’s it. - **Input**; mysqldumping from another machine in the same lan and with internet access and more free space at the time. **Output**; didn’t work, would be really slow and stop at like 1GB - **Input**; Using the mysqldump with a grep to gzip the shit outta it. **Output**; 3GB size file, didn’t bother to import it to see it’s contents. None of these have worked so far, So I feel like my only option here is to have a custom CLI script which exports/imports a certain database’s tables by itself, it should only ask you the IP and Login credentials for the MySQL server where the database is hosted. I could do this job manually myself for one time, but I would like to look to this as an opportunity to develop a tool that can serve me for other sites and situations after this has been solved. The same tool should be able to export and import the tables but do it properly without much user input besides Auth/Login and providing the database name of the ones available on the MySQL server (If the Auth worked) or maybe just create a new one with the name of the *.sql file. I'd rather have this done in Bash, since PHP and Apache might not be available on some VM environments I work with. You would not have access to any of these machines, this script is supposed to work in any situation where certain requirements are met: - Needs to be a .sh script easily editable or CLI app that asks a few inputs before doing it's thing, no Ruby/Python or anything that needs 3rd party repos. - Sometimes not enough freespace to install heavy stuff (dependencies) of various GB's - I need some kind of logging, some kinda of input of what is doing and expected ETA, or at least a "(22/55) tables completed, exporting table 'users'......................" - In case of not enough space, only the table being imported or exported should be corrupted and I expect some way to handle that without much room for error on the user part (Probably the best way would be to add an extension to the files until they're fully exported at least. All my VM's use CentOS 6, so you can work with that to guess what's installed on it or not. If you wish, I can provide additional information in order to you to make a final quote, like detailed OS info and also what apps are already installed , and how much space available there's on each machine. I still expect to be able to use the scripts by myself, but every bit of information I can provide to help you solve this faster, the better. OS and Software - CentOS6.6.6 - 5.5.40 MySQL Community Server (GPL)