• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 764
  • Last Modified:

mysqldump will lock the database table?

mysqldump -u user_name -p password mydatabase > dbbackup.sql

Will the above script lock the database?
If yes, how can i backup the database without lock it? This is because maybe some of the user is running insert or update statement while i doing backup database.

thanks
0
hawkly
Asked:
hawkly
1 Solution
 
UmeshMySQL Principle Technical Support EngineerCommented:
Hi,

try this..

mysqldump --opt -Q  --skip-lock-tables -u user_name -p password mydatabase > dbbackup.sql
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now