Backup a huge database 200gb+ i have a mysql database where i need to take a backup of the log database.

the problem is the log database i over 200gb and contains over 280 millions of rows, i need right now to remove a kind of data but before i can do it i need to take a backup.

i have trying mysqldump function but the problem is here its lock everything and block the website there running right now, and i have trying to do it over ssh tunnel the problems is.

1) the database its contain over 200gb data
2) the internet line its between 20-40mbit internet in download
3) the web server's its pretty slow and i have calculate its take over 4-5 hours thats mean the store is down in thats time.

are there a easy and smart method to take a remotely backup of so larges database before i remove something in the log table?
If your big tables are innodb, you can use --single-transaction to not lock the table.

Other possibility is Percona XtraBackup

Or pt-archiver (again Percona)