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?