Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

mysqldump will lock the database table?

Posted on 2004-09-12
1
Medium Priority
?
763 Views
Last Modified: 2008-02-01
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
Comment
Question by:hawkly
1 Comment
 
LVL 26

Accepted Solution

by:
Umesh earned 200 total points
ID: 12041641
Hi,

try this..

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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question