title: MySQL getting hang up while taking database backup and doing migration
body: <p>I have a MySQL database of a total size ~700GB, with one database table around 250GB having around 70M records and a couple of full-text indexes.</p>
  <p>I want to take the backup of the database and move it to another server, but whenever I am initiating database backup after some time it hangs the entire server, and in one case the data transfer was just 8% even after 6 hrs. So every time I initiate this activity, I have to stop the activity after some time, since it is a production database.</p>
  <p>The server configuration is 128GB RAM with Xeon Processor. I have tried command line mysqldump command, MySQL workbench, SQLYog, HeidiSQL tools for data transfer.</p>
  <p>Any recommendation to make any changes to MySQL conf or how can I improve the data transfer performance.</p>