Is it possible to make a backup of the mysql database if there are records?

Question

MySQL

Good afternoon, I want to dump the database, but due to the huge size, the operation will take a long time so that new records are not lost, I wanted to know if it is possible to dump the database without stopping the write daemon to the database?

Answer 1

What does "records were not lost" mean? If the write happened a minute after the dump was completed, are these lost writes or not?
Just make a backup of the database and there will be all the records at a certain point in time.

Answer 2

Master - Slave do not use?

Answer 3

If the entire database is in InnoDB - Then it is possible, via the command line:
mysqldump --single-transaction ...
Via phpmyadmin - I'm not sure.

Answer 4

What you are talking about is called a hot backup. Perhaps it is worth looking towards the solution https://www.percona.com/software/mysql-database/pe...