Can any one suggest me the efficient way to take backup of Mysql database automatically from linux. So Data integrity is maintained.
Asked
Active
Viewed 84 times
0
-
Possible duplicate of [How to export a mysql database using Command Prompt?](https://stackoverflow.com/questions/3031412/how-to-export-a-mysql-database-using-command-prompt) – SystemGlitch May 10 '18 at 11:51
-
If we are taking the backup of production enviroment then there will be any issue with data integrity or downtime. – May 10 '18 at 11:56
-
For production environment, I can recommend you taking a look at [Database replication](https://dev.mysql.com/doc/refman/5.7/en/replication.html) – SystemGlitch May 10 '18 at 12:01
-
thanks for the solution – May 10 '18 at 12:08
-
Can we use the mysqldump in production enviroment ? – May 11 '18 at 05:01
-
Yes but I won't recommend it if your database is becoming large. The save time would be long, generating a significant downtime. Replication is the way to go because on top of having a backup, you also have an automatic fallback if the server for the main database falls. – SystemGlitch May 11 '18 at 08:28