DelphiFAQ Home Search:
Databases
    InterBase (28)
    MS-SQL (5)
    mysql (33)
    Oracle (1)

 
Exchange Links
 
About this site

Links to us

Tell a friend
Friend's name
Friend's email
My name
My email
Short note
 
Bookmark this
Add to del.icio.us Digg! Add to Reddit Add to Yahoo MyWeb Add to Windows Live Add to Google Bookmarks Share via Facebook

Lock an entire mysql database with all its tables

 

commentsThis article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:

How can I lock my entire mysql database? And how can I lock a single table?

Answer:

Go to the mysql shell and use the FLUSH command.
This clloses all open tables and locks all tables for all databases with a read lock until you execute UNLOCK TABLES. This is very convenient way to get backups.

FLUSH TABLES WITH READ LOCK;

/* alternatively lock a single table:
LOCK TABLES customers READ; 
*/

/* running my backup */

UNLOCK TABLES;

Comments:

2008-04-11, 00:51:52
anonymous from India  
Hai all,

This information about the MySQL in nice..

thank u..!

Keywords:

2008-05-16, 09:46:11
anonymous from Ukraine  
thanks

 

 

Email address (not necessary):

Rate as 		Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option.
 
It seems that you are
from Washington, US .

Info/ Feedback on this

Show city and country
Show country only
Hide my location
Leave your comment here:
Please type in the code:
photo Add a picture:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity. The owner of this web site reserves the right to delete such material.