I have server with db(36Gb data), only mysql access. When i'm trying to use mysqldump utility, i get connection timeout(or something like this).
I doesn't have ssh access for copy /var/mysql/data. It's a production server and i want copy data without any loads on server CPU/IOdisk.
Now i have only one solution. Read batch of data (1000-10000 lines) with script, insert in local database, wait xxx ms.
May be exists ready solutions?